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 |
|
