You can write like this

來源: oops_yz 2011-01-08 20:49:17 [] [舊帖] [給我悄悄話] 本文已被閱讀: 次 (394 bytes)
回答: Please help in SQL code and Thank youluck20102011-01-08 16:28:50

I didn't try to run, but I think you can get the idea if I have some syntax error:

select
c.cust_nam, 
totqty
from
customers c join

(select sum(s.qty_sold) as totqty, cust_id from sales s
where s.sale_dat >= ‘20100101’,
s.sale_dat <= ‘20101231’ group by
cust_id) cnt
c.cust_id = cnt.cust_id,

請您先登陸,再發跟帖!

發現Adblock插件

如要繼續瀏覽
請支持本站 請務必在本站關閉/移除任何Adblock

關閉Adblock後 請點擊

請參考如何關閉Adblock/Adblock plus

安裝Adblock plus用戶請點擊瀏覽器圖標
選擇“Disable on www.wenxuecity.com”

安裝Adblock用戶請點擊圖標
選擇“don't run on pages on this domain”