cd
发帖数: 32 | 1 The following code has error as title (ORA-00918: column ambiguously defined
). Can someone tell me why and how to correct it? The # of rows in each
table is t>> m, c, x, s >a >>r, p
Thanks. | c*****d
发帖数: 6045 | 2 一般情况下
a column name used in a join exists in more than one table and is thus
referenced ambiguously.
我把你的语句重新格式化了一下，我觉得应该是from子句中的那个subquery
SELECT /*+ index(m) index(p) */
t.cs_id,t.t_id,
t.t_sale_amount,
m.ad_amount,
t.user_id,
t.t_mobile_number,
t.ca_care_id,
c.rl_number,
to_char(c.cs_date_of_creation,'mmddyyyyHHMM') cs_date_of_creation,
c.cs_is_void,c.cs_order_id,
s.si_sku,
s.si_unit_price,
s.si_description,
s.si_is_returned,
s.si_quantity,
s.si_returned_restock |
|
