select *
from c_chapter_info b,
(select * from tmp_content where xiuid is null) a
where a.xiu=b.chapter_name and a.version_id=b.version_id
and a.subjectid=b.subjectid
and a.subjectid=b.subjectid
显示结果为两个表所有的列,如果两个表中出现重复列名,系统会自动进行重命名:
比如:chapter_id和chapter_id_1
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9240380/viewspace-668185/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/9240380/viewspace-668185/