Query joining tables (1 Viewer)

joshmacde85

New member
Local time
Today, 13:47
Joined
Jan 5, 2021
Messages
1
I'm trying to make a query where data from two tables that are joined. However, some entries have data from only one table and some have data from both tables. The query is returning only the results that have data in BOTH tables. Is there a way to circumvent this and just return nothing for those columns if the second table does not exist for that entry? TIA!192.168.0.1
 
Last edited:

plog

Banishment Pending
Local time
Today, 03:17
Joined
May 11, 2011
Messages
11,613
Yes, you need a LEFT JOIN:


And here's a link for doing it in Access via the query designer:

 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 04:17
Joined
Feb 19, 2002
Messages
42,981
I've included a picture of 8 Venn diagrams that show how joins can be used to select data. The names are listed down, In the picture, they are left to right so the fourth item in the list is the first item in the second row.
SQLJoinTypes.JPG


 

Users who are viewing this thread

Top Bottom