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