作者Devil

select tableA.f1,tableA.f2,tableA.f3 from tableA
inner join
(
select 'a' as f2,'01' as f3
union
select 'b' as f2,'01' as f3
union
select 'b' as f2,'02' as f3
) as TableB
on TableA.f2 = TableB.f2 and TableA.f3 = TableB.f3
效能可能不怎麼樣,就只是看起來比較直覺而已