34,838
社区成员




--推荐这个.
select tb1.* from tb1,tb2
where tb1.col1 = tb2.col1 and tb1.col2 = tb2.col2
--也可尝试这个
select * from tb1
where exists(select 1 from tb2 where tb2.col1 = tb1.col1 and tb2.col2 = tb1.col2)
select * from tb1
inner join tb2
on tb1.col1=tb2.col1 and tb1.col2=tb2.col2