RE: AW: Use SQL to compare 2 files And Get The Order Right?

[w 4038 <window4038@xxxxxxxx>]

Hi Birgitta
You are an SQL god.  Your coalesce suggestion worked perfectly.
Thank you

-----------------------------
> If the full outer join returns the example you want, but only needs to be
> ordered, just try the following:
 
> Select * 
> FROM tableA FULL OUTER JOIN tableB ON table1.name=table2.name
> Order By Coalesce(Table1.Name, Table2.Name)
 
> Mit freundlichen Grüßen / Best regards
 
> Birgitta Hauser