1,216
社区成员
发帖
与我相关
我的任务
分享
select iif(a.[gl_quantity] is null,0,a.[gl_quantity]) as [quantity0]
,(select sum(b.[rd_quantity])
from [goods_receive_list] as l, [goods_receive_detailed] as b
where b.[gl_id]=a.[id] and b.[rl_id]=l.[id] and l.[rl_date]<=#2008-04-13 23:59:59#) as [quantity1]
,(select sum(b.[cd_quantity])
from [goods_consignment_list] as l, [goods_consignment_detailed] as b
where b.[gl_id]=a.[id] and b.[cl_id]=l.[id] and l.[cl_date]<=#2008-04-13 23:59:59#) as [quantity2]
from [goods_list] as a where a.[id]=136
SELECT a.[id], a.[gl_pn], a.[gl_name_ch], a.[gl_name_en], a.[gl_unit], a.[gl_price], a.[gl_quantity],
(SELECT SUM(rd.[rd_quantity])
FROM [goods_receive_list] AS rl, [goods_receive_detailed] AS rd
WHERE rd.[gl_id] = a.[id] AND rd.[rl_id] = rl.[id]) AS [quantity1],
(SELECT SUM(cd.[cd_quantity])
FROM [goods_consignment_list] AS cl,
[goods_consignment_detailed] AS cd
WHERE cd.[gl_id] = a.[id] AND cd.[cl_id] = cl.[id]) AS [quantity2]
FROM [goods_list] AS a
ORDER BY a.[gl_pn]