2,496
社区成员
发帖
与我相关
我的任务
分享
procedure TForm1.Button4Click(Sender: TObject);
begin
with DM2.ADOQuery1 do
begin
Close;
SQL.Clear;
SQL.Add('Select Name as 库存名称,Sum(Num) as 入库数量 from Stocks');
SQL.Add('group by Name');
Open;
end;
end;
procedure TForm1.Button8Click(Sender: TObject);
begin
with DM2.ADOQuery2 do
begin
Close;
SQL.Clear;
SQL.Add('Select Name as 出库名称,Sum(num) as 出库数量 from OutStocks');
SQL.Add('group by Name');
Open;
end;
end;
select a.库存名称,b.出库数量 as 出库总数,a.入库数量 as 库存总数 from
( Select Name as 库存名称,Sum(Num) as 入库数量 from Stocks group by Name) a,
( Select Name as 出库名称,Sum(num) as 出库数量 from OutStocks group by Name) b
where a.库存名称 = b.出库名称
--试下这样
SELECT 库存名称 = Name,入库数量,出库数量
FROM
(Select Name, Sum(Num) as 入库数量 from Stocks group by Name) A
FULL JOIN (Select Name, Sum(num) as 出库数量 from OutStocks group by Name) B
ON A.NAME = B.NAME
select 库存名称, sum(出库数量) as 出库总数, sum(入库数量) as 库存总数
from (Select Name as 库存名称, 0 as 出库数量, Num as 入库数量
from Stocks
union all
Select Name as 库存名称, num as 出库数量, 0 as 入库数量
from OutStocks) m
group by 库存名称
select * from
( Select Name as 库存名称,Sum(Num) as 入库数量 from Stocks group by Name) a,
( Select Name as 出库名称,Sum(num) as 出库数量 from OutStocks group by Name) b
where a.库存名称 = b.出库名称
SELECT 库存名称 = Name,入库数量,出库数量
FROM
(Select Name, Sum(Num) as 入库数量 from Stocks group by Name) A
FULL JOIN (Select Name, Sum(num) as 出库数量 from OutStocks group by Name) B
ON A.NAME = B.NAME