Select PJ_Temp1.*,PJ_Temp2.PJLXDM,PJ_Temp2.QSHM,PJ_Temp2.ZZHM,PJ_Temp2.FS,PJ_Temp3.PJLXDM as PJLXDM2,PJ_Temp3.QSHM,PJ_Temp3.ZZHM,PJ_Temp3.FS,PJ_Temp4.PJLXDM PJLXDM3,PJ_Temp4.QSHM,PJ_Temp4.ZZHM,PJ_Temp4.FS,PJ_Temp5.PJLXDM PJLXDM4,PJ_Temp5.QSHM,PJ_Temp5.ZZHM,PJ_Temp5.FS into PJ_TEMP1
from PJ_Temp1
RIGHT OUTER JOIN PJ_Temp2 on PJ_Temp1.PJLXDM = PJ_Temp2.PJLXDM
RIGHT OUTER JOIN PJ_Temp3 on PJ_Temp1.PJLXDM = PJ_Temp3.PJLXDM
RIGHT OUTER JOIN PJ_Temp4 on PJ_Temp1.PJLXDM = PJ_Temp4.PJLXDM
RIGHT OUTER JOIN PJ_Temp5 on PJ_Temp1.PJLXDM = PJ_Temp5.PJLXDM
from PJ_Temp1
RIGHT OUTER JOIN PJ_Temp2 on PJ_Temp1.PJLXDM = PJ_Temp2.PJLXDM
RIGHT OUTER JOIN PJ_Temp3 on PJ_Temp1.PJLXDM = PJ_Temp3.PJLXDM
RIGHT OUTER JOIN PJ_Temp4 on PJ_Temp1.PJLXDM = PJ_Temp4.PJLXDM
RIGHT OUTER JOIN PJ_Temp5 on PJ_Temp1.PJLXDM = PJ_Temp5.PJLXDM
PJ_Temp2.QSHM,PJ_Temp2.ZZHM,PJ_Temp2.FS,PJ_Temp3.PJLXDM,--2
PJ_Temp3.QSHM,PJ_Temp3.ZZHM,PJ_Temp3.FS,'PJ_Temp4.PJLXDM,--3
PJ_Temp4.QSHM,PJ_Temp4.ZZHM,PJ_Temp4.FS,PJ_Temp5.PJLXDM,--4
PJ_Temp5.QSHM,PJ_Temp5.ZZHM,PJ_Temp5.FS into PJ_TEMP1 --5
from PJ_Temp1
RIGHT OUTER JOIN PJ_Temp2 on PJ_Temp1.PJLXDM = PJ_Temp2.PJLXDM
RIGHT OUTER JOIN PJ_Temp3 on PJ_Temp1.PJLXDM = PJ_Temp3.PJLXDM
RIGHT OUTER JOIN PJ_Temp4 on PJ_Temp1.PJLXDM = PJ_Temp4.PJLXDM
RIGHT OUTER JOIN PJ_Temp5 on PJ_Temp1.PJLXDM = PJ_Temp5.PJLXDM建议Select PJ_Temp1.*,PJ_Temp2.PJLXDM as PJLXDM1,--1
PJ_Temp2.QSHM,PJ_Temp2.ZZHM,PJ_Temp2.FS,PJ_Temp3.PJLXDM as PJLXDM2,--2
PJ_Temp3.QSHM,PJ_Temp3.ZZHM,PJ_Temp3.FS,'PJ_Temp4.PJLXDM as PJLXDM3,--3
PJ_Temp4.QSHM,PJ_Temp4.ZZHM,PJ_Temp4.FS,PJ_Temp5.PJLXDM as PJLXDM4,--4
PJ_Temp5.QSHM,PJ_Temp5.ZZHM,PJ_Temp5.FS into PJ_TEMP1
from PJ_Temp1
RIGHT OUTER JOIN PJ_Temp2 on PJ_Temp1.PJLXDM = PJ_Temp2.PJLXDM
RIGHT OUTER JOIN PJ_Temp3 on PJ_Temp1.PJLXDM = PJ_Temp3.PJLXDM
RIGHT OUTER JOIN PJ_Temp4 on PJ_Temp1.PJLXDM = PJ_Temp4.PJLXDM
RIGHT OUTER JOIN PJ_Temp5 on PJ_Temp1.PJLXDM = PJ_Temp5.PJLXDM
PJ_Temp3
PJ_Temp4
表里面都有列PJLXDM你查询的时候可以用别名
现在又出现了以下错误:
名表中的列名必须唯一,在表'PJ_Temp1'中多次指定了列名'PJ_Temp1.QSHM'
from PJ_Temp1 /*这里换个名字 */
RIGHT OUTER JOIN PJ_Temp2 on PJ_Temp1.PJLXDM = PJ_Temp2.PJLXDM
RIGHT OUTER JOIN PJ_Temp3 on PJ_Temp1.PJLXDM = PJ_Temp3.PJLXDM
RIGHT OUTER JOIN PJ_Temp4 on PJ_Temp1.PJLXDM = PJ_Temp4.PJLXDM
RIGHT OUTER JOIN PJ_Temp5 on PJ_Temp1.PJLXDM = PJ_Temp5.PJLXDM
from PJ_Temp1
RIGHT OUTER JOIN PJ_Temp2 on PJ_Temp1.PJLXDM = PJ_Temp2.PJLXDM
RIGHT OUTER JOIN PJ_Temp3 on PJ_Temp1.PJLXDM = PJ_Temp3.PJLXDM
RIGHT OUTER JOIN PJ_Temp4 on PJ_Temp1.PJLXDM = PJ_Temp4.PJLXDM
RIGHT OUTER JOIN PJ_Temp5 on PJ_Temp1.PJLXDM = PJ_Temp5.PJLXDM
from PJ_Temp1
RIGHT OUTER JOIN PJ_Temp2 on PJ_Temp1.PJLXDM = PJ_Temp2.PJLXDM
RIGHT OUTER JOIN PJ_Temp3 on PJ_Temp1.PJLXDM = PJ_Temp3.PJLXDM
RIGHT OUTER JOIN PJ_Temp4 on PJ_Temp1.PJLXDM = PJ_Temp4.PJLXDM
RIGHT OUTER JOIN PJ_Temp5 on PJ_Temp1.PJLXDM = PJ_Temp5.PJLXDM同时,由于新建一个表,所使用的列名都是用原来select中得出的,所以应该不使重名出现,如果有的话,使用 比如 select table1.column as newname的方式变成不同的名字
分别取PJ_Temp2、PJ_Temp3、PJ_Temp4、PJ_Temp5的数据合并到PJ_Temp1中。有高手帮忙一下啦!先谢了。可以再加分!!!
from PJ_Temp1
RIGHT OUTER JOIN PJ_Temp2 on PJ_Temp1.PJLXDM = PJ_Temp2.PJLXDM
RIGHT OUTER JOIN PJ_Temp3 on PJ_Temp1.PJLXDM = PJ_Temp3.PJLXDM
RIGHT OUTER JOIN PJ_Temp4 on PJ_Temp1.PJLXDM = PJ_Temp4.PJLXDM
RIGHT OUTER JOIN PJ_Temp5 on PJ_Temp1.PJLXDM = PJ_Temp5.PJLXDM你不要偷懒,把要显示的列名都写出来,保证不要有重复的列名,即使有也用: xx as 列别名 来加个别名。
drop table PJ_Temp1Select PJ_Temp1.*,PJ_Temp2.QSHM,PJ_Temp2.ZZHM,
PJ_Temp2.FS,PJ_Temp3.QSHM,PJ_Temp3.ZZHM,
PJ_Temp3.FS,PJ_Temp4.QSHM,PJ_Temp4.ZZHM,
PJ_Temp4.FS,PJ_Temp5.QSHM,PJ_Temp5.ZZHM,
PJ_Temp5.FS into PJ_TEMP1
from #temp
RIGHT OUTER JOIN PJ_Temp2 on #temp.PJLXDM = PJ_Temp2.PJLXDM
RIGHT OUTER JOIN PJ_Temp3 on #temp.PJLXDM = PJ_Temp3.PJLXDM
RIGHT OUTER JOIN PJ_Temp4 on #temp.PJLXDM = PJ_Temp4.PJLXDM
RIGHT OUTER JOIN PJ_Temp5 on #temp.PJLXDM = PJ_Temp5.PJLXDM