selecting duplicate values with a condition from a mysql table
select * from Table1 t
where not exists(
  select 1 from Table1 p where p.FD = t.FD
      and p.FA != t.FA and p.FA = 1
);


Or as a LEFT JOIN (might be better optimized on 5.5)

select t.* from Table1 t
left join Table1 p on p.FD = t.FD
      and p.FA != t.FA and p.FA = 1
where p.`Key` is null;


http://sqlfiddle.com/#!9/39664/4