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
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