SQL2005 求join不重复行
SQL2005 求join不重复行
表:客户表trader
traderid,tradercode,tradername
1001,A001, A客户
1002,A002, B客户
1003,C007, C客户
3007,D002, D客户
9008,K2133, F客户
视图1:vip_sale
traderid,billdate,billcde,materialid,quantity
1001,2017-11-01,BC001, 3001,8000
1001,2017-11-01,BC001, 3002,7000
视图2:vip_sreturn
traderid,hlbilldate,hlbillcde,hlmaterialid,hlquantity
1001,2017-11-02,KK001, 2001,8000
3007,2017-11-03,KK003, 7007,8099
视图3:vip_charge
traderid,amount1,amount2,amount3
1001,300,400,500
9008,271,272,273
以trader表作为源头行链接
求结果生成视图vip_tradersalesreturnchargebb
内容行不要重复
traderid,tradercode,tradername,billdate,billcde,materialid,quantity,hlbilldate,hlbillcde,hlmaterialid,hlquantity,amount1,amount2,amount3
1001 ,A001, A客户, 2017-11-01,BC001, 3001,8000 ,2017-11-02,KK001, 2001,8000,300,400 ,500
1001 ,A001, A客户, 2017-11-01,BC001, 3002,7000 ,NULL ,NULL ,NULL ,NULL,NULL,NULL,NULL
1002 ,A002, B客户, NULL,NULL, NULL,NULL ,NULL ,NULL ,NULL ,NULL,NULL,NULL,NULL
1003 ,C007, C客户, NULL,NULL, NULL,NULL ,NULL ,NULL ,NULL ,NULL,NULL,NULL,NULL
3007 ,D002, D客户,, NULL,NULL, NULL,NULL ,2017-11-03,KK003, 7007,8099,NULL,NULL,NULL
9008 ,K2133, F客户, NULL,NULL, NULL,NULL ,NULL ,NULL ,NULL ,NULL,271,272,273