Access - Outer Join

[sflau]

I am using Access 2000, but I find that I can't use "Full Outer Join", does Access 2000 suppoer Full Outer Join? But, in access, I can use left outer join / right outer join. Why?

Here is my SQL statement, please help:

select * from
(select Field1, Field2 from Table1 where Field2 = 1) T1
left outer join
(select Field1, Field2 from Table2 where Field2 = 2) T2
on T1.Field1= T2.Field1

 

[swampBoogie]

There is no support for full outer join in Access/Jet. Y

select * from 
t1 full outer join t2 on t1.c1 = t2.c1

is the same as

select * 
  from t1 left outer join t2
  on t1.c1 = t2.c1 
 where t2.c1 is null
union all
select * from t1 inner join t2 
  on t1.c1 = t2.c1
union all
select t1 right outer join t2
  on t1.c1 = t2.c1
 where t1.c1 is null

 

[sflau]

I get it, thank you.