这个sql有N读多个重复的 写复杂的查询语句 可以用试图 来写吗 之后copy到 后台里

问题描述

SELECTDISTINCTdbo.business1.productASExpr6,dbo.business1.markASExpr7,dbo.business1.competeASExpr8,dbo.business1.sellASExpr9,dbo.business1.sellmodeASExpr10,dbo.business1.last_1_inASExpr11,dbo.business1.last_2_inASExpr12,dbo.business1.last_3_inASExpr13,dbo.business1.last_1_getASExpr14,dbo.business1.last_2_getASExpr15,dbo.business1.last_3_getASExpr16,dbo.business1.future_1_inASExpr17,dbo.business1.future_2_inASExpr18,dbo.business1.future_3_inASExpr19,dbo.business1.future_1_getASExpr20,dbo.business1.future_2_getASExpr21,dbo.business1.future_3_getASExpr22,dbo.business1.FileUpload1nameASExpr23,dbo.business1.FileUpload2nameASExpr24,dbo.business2.connASExpr29,dbo.business2.mobileASExpr30,dbo.business2.tellASExpr31,dbo.business2.faxASExpr32,dbo.business2.emailASExpr33,dbo.business2.websiteASExpr34,dbo.business2.addressASExpr35,dbo.business2.groupinfoASExpr36,dbo.business.usertypeASExpr37,dbo.business.infotypeASExpr38,dbo.business.itemnameASExpr39,dbo.business.keywordASExpr40,dbo.business.itemtypeASExpr41,dbo.business.hangyeclassASExpr42,dbo.business.developmentASExpr43,dbo.business.fundtimeASExpr44,dbo.business.fundobjectASExpr45,dbo.business.showfundASExpr46,dbo.business.fundhowASExpr47,dbo.business.moneytypeASExpr48,dbo.business.exittypeASExpr49,dbo.business.itemintroASExpr50,dbo.business.addtimeASaddtime,dbo.business.yes_noASExpr52FROMdbo.businessCROSSJOINdbo.business2CROSSJOINdbo.business1我希望能在三章表里选出表3.type和表3.infotype表3.type=表2.type表3.type=表1.type表3.infotype=表2.infotype表3.infotype=表1.infotype表3的type和infotype一定存在但是表2和表1的type和infotype不一定存在

解决方案

解决方案二：
d
解决方案三：
d
解决方案四：
建议楼主重新把问题描述一下，特别是那个标题。。。