这样的SQL语句应该怎样写??
表A中有字段fdA
当A.fdA= 'A '
取表B中所有字段
否则
取表C中所有字段
------解决方案--------------------select f1,f2,f3,....
from (
select b.f1,b.f2,b.f3...., 'a ' as b.fa
from b
union all
select c.f1,c.f2,c.f3...., 'b ' as c.fa
from c) as t
where t.fa in (select fda from a)