初学者求复杂的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)