sql求解》》》》》》》》》》
INSERT INTO 表C (so,NAME,fqty,欠料)
SELECT b.so,b.name,b.fqty,a.fqty-b.fqty AS 欠料 FROM 表B AS b
LEFT JOIN 表A AS a ON b.name= a.name
SELECT B.SO
,B.NAME
,B.QL
,NVL(A.FQTY,0)-B.FQTY QL
FROM TABLEB B LEFT JOIN TABLEA A ON A.NAME = B.NAME
INSERT INTO 表C (so,NAME,fqty,欠料)
SELECT b.so,b.name,b.fqty,a.fqty-b.fqty AS 欠料 FROM 表B AS b
LEFT JOIN 表A AS a ON b.name= a.name
SELECT B.SO
,B.NAME
,B.QL
,NVL(A.FQTY,0)-B.FQTY QL
FROM TABLEB B LEFT JOIN TABLEA A ON A.NAME = B.NAME