楼上的太简单了,我把所有的SQL语给贴上来吧 Select E.F_ItemNo,S.F_Tabledate,Concat(E.F_ItemName,'/',E.F_ItemDesc) F_ItemName,E.F_Unit,S.F_Itemidate A,S.F_Itemino B,S1.F_Prodno C,'入库' D ,S1.F_Inqty E,0 F ,Ma.G,0 H From T_WinStockh S,T_Winstocki S1,T_EItem E ,(Select Sum(S1.F_Inqty) G, E.F_ItemNo From T_WinStockh S,T_Winstocki S1,T_EItem E Where S.F_Itemino=S1.F_Itemino And E.F_ItemNo=S1.F_ItemNo Group by E.F_ItemNo ) Ma Where S.F_Itemino=S1.F_Itemino And E.F_ItemNo=S1.F_ItemNo And Ma.F_ItemNo=S1.F_ItemNo Union all Select E.F_ItemNo,W.F_Tabletime,Concat(E.F_ItemName,'/',E.F_ItemDesc) F_ItemName,E.F_Unit, W.F_Outdate A,W.F_Outno B,W1.F_Prodno C,'出库' D,0 E ,W1.F_Outqty F ,0 G,Ma.H From T_Wouth W,T_Wouti W1,T_EItem E ,(Select Sum(W1.F_Outqty) H, E.F_ItemNo From T_Wouth W,T_Wouti W1,T_EItem E Where W.F_OutNo=W1.F_OutNo And E.F_ItemNo=W1.F_ItemNo Group by E.F_ItemNo ) Ma Where W.F_OutNo=W1.F_OutNo And E.F_ItemNo=W1.F_ItemNo And Ma.F_ItemNo=W1.F_ItemNo Union all Select E.F_ItemNo,B11.F_Tabledate,Concat(E.F_ItemName,'/',E.F_ItemDesc) F_ItemName,E.F_Unit,B11.F_Outbkdate A,B11.F_OutbkNo B,B1.F_ProdNo C,'退回' D,B1.F_Outbkqty E,0 F ,Ma.G,0 H From T_Woutbackh B11,T_WoutbacKi B1 ,T_EItem E ,(Select Sum(B1.F_Outbkqty) G, E.F_ItemNo From T_Woutbackh B11,T_WoutbacKi B1 ,T_EItem E Where B11.F_Outbkno=B1.F_Outbkno And E.F_ItemNo=B1.F_ItemNo Group by E.F_ItemNo ) Ma Where B11.F_Outbkno=B1.F_Outbkno And E.F_ItemNo=B1.F_ItemNo And Ma.F_ItemNo=B1.F_ItemNo我还没有加入求上期结存的SQL语句.
Select E.F_ItemNo,S.F_Tabledate,Concat(E.F_ItemName,'/',E.F_ItemDesc) F_ItemName,E.F_Unit,S.F_Itemidate A,S.F_Itemino B,S1.F_Prodno C,'入库' D ,S1.F_Inqty E,0 F ,Ma.G,0 H
From T_WinStockh S,T_Winstocki S1,T_EItem E ,(Select Sum(S1.F_Inqty) G, E.F_ItemNo From T_WinStockh S,T_Winstocki S1,T_EItem E Where S.F_Itemino=S1.F_Itemino And E.F_ItemNo=S1.F_ItemNo Group by E.F_ItemNo ) Ma
Where S.F_Itemino=S1.F_Itemino And E.F_ItemNo=S1.F_ItemNo And Ma.F_ItemNo=S1.F_ItemNo
Union all
Select E.F_ItemNo,W.F_Tabletime,Concat(E.F_ItemName,'/',E.F_ItemDesc) F_ItemName,E.F_Unit, W.F_Outdate A,W.F_Outno B,W1.F_Prodno C,'出库' D,0 E ,W1.F_Outqty F ,0 G,Ma.H
From T_Wouth W,T_Wouti W1,T_EItem E ,(Select Sum(W1.F_Outqty) H, E.F_ItemNo From T_Wouth W,T_Wouti W1,T_EItem E Where W.F_OutNo=W1.F_OutNo And E.F_ItemNo=W1.F_ItemNo Group by E.F_ItemNo ) Ma
Where W.F_OutNo=W1.F_OutNo And E.F_ItemNo=W1.F_ItemNo And Ma.F_ItemNo=W1.F_ItemNo
Union all
Select E.F_ItemNo,B11.F_Tabledate,Concat(E.F_ItemName,'/',E.F_ItemDesc) F_ItemName,E.F_Unit,B11.F_Outbkdate A,B11.F_OutbkNo B,B1.F_ProdNo C,'退回' D,B1.F_Outbkqty E,0 F ,Ma.G,0 H
From T_Woutbackh B11,T_WoutbacKi B1 ,T_EItem E ,(Select Sum(B1.F_Outbkqty) G, E.F_ItemNo From T_Woutbackh B11,T_WoutbacKi B1 ,T_EItem E Where B11.F_Outbkno=B1.F_Outbkno And E.F_ItemNo=B1.F_ItemNo Group by E.F_ItemNo ) Ma
Where B11.F_Outbkno=B1.F_Outbkno And E.F_ItemNo=B1.F_ItemNo And Ma.F_ItemNo=B1.F_ItemNo我还没有加入求上期结存的SQL语句.