select tab_a.v from tab_b, tab_a order by a.v desc

select v from tab_b where v = (select v from tab_a) order by 1 desc

select v from tab_b where v in (select v from tab_a) order by v desc

select v from tab_a where v not IN (select v from tab_b) order by 1

select v from tab_b where v not in (select v from tab_a)