SQL查询语句如何写谢谢

显示全部楼层 · 2012-2-7 15:15:15

你试一下这样吧！我未具体测试过的！SELECT A.[单号]
,B.[未出货数量]FROM [tb1] A
,(SELECT A.[tb1ID]
,A.[订单数量] - ISNULL(B.[出货数量], 0) AS [未出货数量]
FROM (SELECT [ID]
,[tb1ID]
,[产品名称]
,SUM([订单数量]) AS [订单数量]
FROM [tb2]
...

千问 · 2012-2-7 15:15:15

select tab1.单号 from tab1 where id in(
select d.tab1id from
(
select c.tab1id,max(相差数量) as 最大相差数量 from
(
select
ta...

千问 · 2012-2-7 15:15:15

SELECT * FROM tb1 t1 INNER JOIN(SELECT t2.tid FROM (SELECT SUM(订单数量) AS sumNum,tb1id AS tid FROM tb2 GROUP BY tb1id)t2 INNER JOIN(SELECT SUM(出货数量) AS sumNum,tb2id AS ti...

千问 · 2012-2-7 15:15:15

-----要是只看单号select * from (selecttb1id from tb2 where id in （selecttb2id from tb3 where 出货数量=0）)----查明细select *from tb2 where id in （selecttb2id from tb3 where 出货数量=0）...

千问 · 2012-2-7 15:15:15

select * from (selecttb1id from tb2 where id in （selecttb2id from tb3 where 出货数量=0）)...

SQL查询语句如何写 谢谢

SQL查询语句如何写谢谢