select TP_Title as Title from TB_Resource_TeachingPlan union all select Mat_Title as Title from TB_Resource_Matter
设置别名为不同的名字:select * from (select TP_Title as Title1 from TB_Resource_TeachingPlan) as A1, (select Mat_Title as Title2 from TB_Resource_Matter) as A2在选择列表中只选择一个Title:select A1.*, A2.除了Title外的其他字段 from (select TP_Title as Title from TB_Resource_TeachingPlan) as A1, (select Mat_Title as Title from TB_Resource_Matter) as A2
select a1.title from (select TP_Title as Title from TB_Resource_TeachingPlan) as A1, (select Mat_Title as Title from TB_Resource_Matter) as A2 where a1.title = a2.title
select TP_Title as Title from TB_Resource_TeachingPlan
union all
select Mat_Title as Title from TB_Resource_Matter
(select TP_Title as Title1 from TB_Resource_TeachingPlan) as A1,
(select Mat_Title as Title2 from TB_Resource_Matter) as A2在选择列表中只选择一个Title:select A1.*,
A2.除了Title外的其他字段
from
(select TP_Title as Title from TB_Resource_TeachingPlan) as A1,
(select Mat_Title as Title from TB_Resource_Matter) as A2
(select TP_Title as Title from TB_Resource_TeachingPlan) as A1,
(select Mat_Title as Title from TB_Resource_Matter) as A2
where a1.title = a2.title