Outer Join in AccessLocked
I see that Access is mentioned and I have an Access question. Can you help?I set up an outer join comparing 2 tables in Access. I followed the MS Access Manual, though, this is my first experience using Access since I have only worked with IBM DB2 in the past. Where can I read more on how to setup Access for outer joins correctly? My test set is small and I know I have rows in one table but not in another and they are not being selected when I run the outer join select statement. PS. I was demoing Access and if this worked, I would have purchased a copy but my trial time expired. I was helping a friend. Thanks ahead of time!