Hi.
Access does not seem to support Full outer join like Sql Server. So, is there any way around it?
Hi.
Access does not seem to support Full outer join like Sql Server. So, is there any way around it?
Access does outer joins.
dbl click the join,
select which table to show all records.
Sorry but you're wrong.
First of all a union query doesn't append anything. Its just two or more select queries run in turn.
Secondly if constructed correctly it does exactly what a full outer join does in e.g. sql server.
See this link if my meaning isn't clear https://datatofish.com/full-outer-join-in-access/
Thanks for the link. It worked for the two column tables. But I'm not sure if it will work for tables with more than two columns.Sorry but you're wrong.
First of all a union query doesn't append anything. Its just two or more select queries run in turn.
Secondly if constructed correctly it does exactly what a full outer join does in e.g. sql server.
See this link if my meaning isn't clear https://datatofish.com/full-outer-join-in-access/
Last edited by bubai; 11-20-2019 at 04:37 AM.
Sorry I made a typo. What I meant was- I'm not sure if it will work for tables with more than two columns. But it does. However my observation is that if any of the queries with Left join or Right join join contains Null values then it does not work and returns duplicates.
I think that would be true in sql server as well. A null is not equal to anything, not even another null.
You might consider using the Nz function in both the left join and right join parts
If that still doesn't help, as I requested before, please upload a cut down database with sample data to show your issue.
Thanks a lot for your help.I think that would be true in sql server as well. A null is not equal to anything, not even another null.
You might consider using the Nz function in both the left join and right join parts
If that still doesn't help, as I requested before, please upload a cut down database with sample data to show your issue.