sql语句:SELECT TOP (100) PERCENT dbo.JHTJ.CPTH AS DDBH, dbo.CPTJ.CPTH AS JKBh, dbo.FPHJ.BH AS KPBH, dbo.JHTJ.DDND, dbo.JHTJ.JHHJ, dbo.JHTJ.SCHJ, dbo.JHTJ.WGHJ,
dbo.CPTJ.ND, dbo.CPTJ.JKHJ, dbo.CPTJ.HDHJ, dbo.FPHJ.FPNF, dbo.FPHJ.FPSL
FROM dbo.JHTJ FULL OUTER JOIN
dbo.FPHJ ON dbo.JHTJ.CPTH = dbo.FPHJ.BH AND dbo.JHTJ.DDND = dbo.FPHJ.FPNF FULL OUTER JOIN
dbo.CPTJ ON dbo.JHTJ.CPTH = dbo.CPTJ.CPTH AND dbo.JHTJ.DDND = dbo.CPTJ.ND
GROUP BY dbo.JHTJ.CPTH, dbo.JHTJ.DDND, dbo.CPTJ.ND, dbo.JHTJ.JHHJ, dbo.JHTJ.SCHJ, dbo.JHTJ.WGHJ, dbo.CPTJ.JKHJ, dbo.CPTJ.HDHJ, dbo.FPHJ.FPNF, dbo.FPHJ.FPSL,
dbo.FPHJ.BH, dbo.CPTJ.CPTH
ORDER BY DDBH, JKBh, KPBH, dbo.JHTJ.DDND, dbo.CPTJ.ND