题目
有如下三张表G1102A(仓库期初)
G1102B(仓库发出)
G1102C(仓库收入)
要求得到如下结果:
该如何写这个SQL?
测试语句
CREATE TABLE G1102A
(WAREHOUSE VARCHAR(10),
ITEM VARCHAR(10),
QTY INT)
INSERT INTO G1102A VALUES ('A','P001',100);
INSERT INTO G1102A VALUES ('A','P002',200);
INSERT INTO G1102A VALUES ('B','P001',120 );
CREATE TABLE G1102B
(WAREHOUSE VARCHAR(10),
ITEM VARCHAR(10),
QTY INT
)
INSERT INTO G1102B VALUES ('A','P001',50);
INSERT INTO G1102B VALUES ('B','P001',30);
CREATE TABLE G1102C
(WAREHOUSE VARCHAR(10),
ITEM VARCHAR(10),
QTY INT
)
INSERT INTO G1102C VALUES ('A','P001',10);
INSERT INTO G1102C VALUES ('A','P002',20);
INSERT INTO G1102C VALUES ('C','P001',15);
INSERT INTO G1102C VALUES ('C','P003',10);