SQL查询出错
SELECT Data0010.Abbr_name,
Data0050.CUSTOMER_PART_NUMBER,
DATA0059.CUSTOMER_PART_desc,
DATA0008.PRODUCT_NAME,
data0060.sales_order,
data0064.date_shipped,
sum(data0064.quan_shipped)+sum(data0064.ovsh_qty) as number,
DATA0060.ADD_PRICE1,
DATA0060.ADD_PRICE2,
DATA0060.ADD_PRICE3,
DATA0060.ADD_PRICE4,
DATA0060.PART_PRICE,
data0001.curr_code,
data0064.part_price,
data0064.part_price/data0060.exch_rate as natural,
(sum(data0064.quan_shipped)*data0060.add_price1+sum(data0064.ovsh_qty)*data0060.add_price1*(100-data0064.ovsh_discount)*0.01)/data0060.exch_rate as money1,
(sum(data0064.quan_shipped)*data0060.add_price2+sum(data0064.ovsh_qty)*data0060.add_price2*(100-data0064.ovsh_discount)*0.01)/data0060.exch_rate as money2,
(sum(data0064.quan_shipped)*data0060.add_price3+sum(data0064.ovsh_qty)*data0060.add_price3*(100-data0064.ovsh_discount)*0.01)/data0060.exch_rate as money3,
(sum(data0064.quan_shipped)*data0060.add_price4+sum(data0064.ovsh_qty)*data0060.add_price4*(100-data0064.ovsh_discount)*0.01)/data0060.exch_rate as money4,
(sum(data0064.quan_shipped)*data0064.part_price+sum(data0064.ovsh_qty)*data0064.part_price*(100-data0064.ovsh_discount)*0.01)/data0060.exch_rate as money5
into #temp2
FROM Data0060
inner join DATA0064 on Data0064.so_ptr=data0060.rkey
inner join DATA0050 on Data0060.CUST_PART_PTR = Data0050.RKEY
inner join DATA0025 on DATA0025.ANCESTOR_PTR=DATA0050.RKEY AND Data0025.PARENT_PTR = 0
inner join DATA0010 on DATA0060.CUSTOMER_PTR=DATA0010.RKEY
inner join DATA0008 on DATA0025.PROD_CODE_PTR=DATA0008.RKEY
left join data0047 on DATA0047.PARAMETER_PTR=2 AND Data0025.RKEY = Data0047.SOURCE_POINTER
left join data0059 on Data0060.CUSTOMER_PTR = data0059.customer_ptr AND Data0060.CUST_PART_PTR = data0059.cust_part_ptr
inner join data0001 on data0060.currency_ptr=data0001.rkey
where data0064.date_shipped>='2009-05-01 00:00:00' and data0064.date_shipped<='2009-05-31 23:59:59'
group by Data0010.Abbr_name , Data0050.CUSTOMER_PART_NUMBER,
DATA0059.CUSTOMER_PART_desc, DATA0008.PRODUCT_NAME, DATA0060.PART_PRICE,
data0060.sales_order,DATA0064.ovsh_discount,Data0060.EXCH_RATE,data0064.date_shipped,
DATA0060.ADD_PRICE1 ,DATA0060.ADD_PRICE2,DATA0060.ADD_PRICE3,
DATA0060.ADD_PRICE4,DATA0060.PART_PRICE,
data0001.curr_code,data0064.part_price,data0064.part_price/data0060.exch_rate
ORDER BY Data0010.Abbr_name, Data0050.CUSTOMER_PART_NUMBER
我是新手,就各位大侠多多指教.此查询执行时提示“服务器: 消息 2705,级别 16,状态 3,行 1
各表中的列名必须唯一。在表 '#temp2' 中多次指定了列名 'part_price'。”,是哪里有问题.