insert into #t1 values(1,'MS-SQL','Microsoft')
insert into #t1 values(2,'Delphi','Borland')
insert into #t2 values(1,'MS-VC++','Microsoft')
insert into #t2 values(2,'C++ Builder','Borland')
select * from #t1
select * from #t2
select a.id,a.title,a.articles from #t1 a where a.title like '%MS-%'union all select b.id,b.title,b.articles from #t2 b
where b.title like '%MS-%'
/*结果
1 MS-SQL Microsoft
2 Delphi Borland