You can write like this

来源: oops_yz 2011-01-08 20:49:17 [] [旧帖] [给我悄悄话] 本文已被阅读: 0 次 (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”