请教一条SQL语句的写法

[janlay]

在一次检索A表的全部字段时，有一个列f,我想在检查它是否存在于B表的某列f中，并将这个结果作为检索结果的新列，并且要依此排序。这样写行不行？

select a.*,a.f in(select f from b) as result from a order by result

[pengdali]

select a.*,case when f in (select f from b) then '存在' else '不存在' end result from a order by case when f in (select f from b) then '存在' else '不存在' end

[CrazyFor]

select a.*,b.f from a left join b on a.f=b.f order by b.f

[CrazyFor]

select a.*,b.f from a left join b on a.f=b.f order by b.f

[chao778899]

select a.*,case when f in (select f from b) then '存在' else '不存在' end result from a order by result
行吗？

[zjcxc]

select a.*,aa=case when exists(select 1 from b where f=a.f) then '存在' else '不存在' from a order by aa