SQL-Joins

[malzusrex]

Ohne getestet zu haben eventuell so:

Select * from FileA a
where exists (Select * from FileB B where a.key1 = b.key1)
union all
Select * from FileA c
where not exists (Select * from FileB d where c.key1 = d.key1)
union all
Select * from FileB e
where not exists (Select * from FileA f where e.key1 = f.key1) 

[B.Hauser]

Wenn Du auf Release 6.1 oder höher bist:

Select  a.*, b.*
From FileA a Full Outer Join FileB b
   on a.key1 = b.Key1
     and a.Key2 = b.Key2
     and ....
     and a.KeyN = b.KeyN

vor 6.1

   Select a.*, b.*
   From FileA a Left Outer Join FileB b on a.Key1 = b.Key1 ....
Union
   Select a.*, b.*
   From FileA a Right Outer Join FileB b. on a.Key1 = b.Key1 ....;