Full Outer Join in Access 2010

[tabos23]

Hello to everyone,

I would like to create a full outer join in Access2010 between two tables with many to many relationship.

So I have tblServer and tblApplication and there is also the ServerID-ApplicationID table that connects these tables.
I found online many examples but all of them where for two tables with one-to-many relationship.
Could anyone please help?

Thank you in advance!

 

[CJ_London]

All that relationships enforce is whatever rules you have set for that relationship - they do not affect joins as such which can be changed in the query as required

However Full Outer Joins are not available in Access, you need to use a union query and left/right joins to get the equivalent result

Here are a couple of links

http://stackoverflow.com/questions/19615177/how-do-i-write-a-full-outer-join-query-in-access


http://www.databasejournal.com/feat...-of-a-FULL-OUTER-JOIN-in-Microsoft-Access.htm

 

[namliam]

Sounds like somewhat of a design issue?
There should never be 2 tables with a many to many relationship?
This should be resolved by a third table?

 

[jdraw]

See this youtube video by TrainSignal re Many to Many

 

[tabos23]

Yes of course there is a third table that connects these two...You can see attached the photo that shows their connection.

 

[jdraw]

So tabos23, have you solved the problem/issue? Are you showing your solution based on the responses to your original post. Or is this still to be resolved?

 

[CJ_London]

So I'm confused. In your original post you said two tables with many to many relationship, but now you are saying three tables with one to many relationships.

Since you have one to many relationships so a record cannot be created in the linking table unless the relevant records exist in the other tables, what is the benefit of a full outer join?