初学者求复杂的SQL语句, 如何写?? 谢谢
sql中有5个表,
A表--JOB,
JOBNO, P_CODE, LOT, QTY
B表--RESVT
P_CODE, CODE, LOT, QTY, DEFA_QTY, QTY1
C表--PCT
PCNO, PDNO, JOBNO, PLOT, P_CODE, QTY2
D表--MATPCT
PCNO, JOBNO, PLOT, P_CODE, CODE, QTY3
E表--MRT
MRNO, JOBNO, CODE, P_CODE, QTY4
需求结果:
JOBNO,PCNO, PDNO,MRNO, P_CODE,CODE, QTY, DEFA_QTY, QTY1,SUM(QTY2), SUM(QTY3), SUM(QTY4)
