select case when t1.name is null then t2.name else t1.name end as t_name ,t1.english ,t2.french from (select name,english from tabname where french is null) t1 full join (select name,french from tabname where english is null) t2 on t1.name = t2.name
