我的Sql語法如下，錯誤訊息是說，字查詢有多筆資料傳回，在子查詢之後不允許=,!=,<,<=... 應該要怎麼寫才對？麻煩各位大大…THS update TMP_Holid set stock_q = (select sum(isnull(si.current_qty,0) isnull(si.diff_qty,0) ) as stock_q from store_invd si,tmp_Holid where si.store_code <> '0086' and si.invd_date = '20050109' and si.item_no =Tmp_Holid.item_no group by si.item_no) , by_way_q = (select sum(si.by_way_qty) as by_way_q from store_invd si, tmp_holid where si.store_code <> '0086' and si.invd_date = '20050109' and si.item_no =Tmp_Holid.item_no group by si.item_no) where item_no in (select distinct item_no from store_invd where invd_date = '20050109')

Hi, 看起來, 是你的 set xx=value 的 value 傳回了多筆資料, 建議你在下達 update 指令之前, 先利用 select 語法將資料帶出, 測試看語法及資料和子查詢筆數是否正確, 再行 update!!

改成下列方式應該就可以了    update TMP_Holid 
  set stock_q = (select sum(isnull(si.current_qty,0)
                        isnull(si.diff_qty,0) ) as stock_q
                from store_invd si 
                where si.store_code <> '0086' and si.invd_date = '20050109'
                  and si.item_no =Tmp_Holid.item_no) , // Group By 拿掉(因為不需要了)
      y_way_q = (select sum(si.by_way_qty) as by_way_q
                from store_invd si where si.store_code <> '0086'
                 and si.invd_date = '20050109'
                 and si.item_no =Tmp_Holid.item_no) // Group By 拿掉(因為不需要了)
where item_no in (select distinct item_no from store_invd
                  where invd_date = '20050109')

_______________________________________ 深藍的魚，祝您好運..........連連

把