MS SQL full outer join help

[ngubie]

hi guys,

 

im trying to implement a full outer join in MS Access. since access is stupid and doesn't support a full outer join, i made my script as follows

 

select ....

from A inner join B

on A.field1 = B.field1 and A.field2 = B.field2

union all

select ....

from A left join B

on A.field1 = B.field1 and A.field2 = B.field2

union all

select ....

from A right join B

on A.field1 = B.field1 and A.field2 = B.field2

 

but my problem is when one of the tables doesn't have an entry for field1 or field2, the rest of the data is still displayed but those fields are null. is there a way i can make it so that

if field1 and field2 are present in any table, display that row WITH the field1 and 2 filled in?