Query joining tables

[joshmacde85]

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

 

[plog]

Yes, you need a LEFT JOIN:

W3Schools.com

W3Schools offers free online tutorials, references and exercises in all the major languages of the web. Covering popular subjects like HTML, CSS, JavaScript, Python, SQL, Java, and many, many more.

www.w3schools.com

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

MS Access 2003: Create a query using a Left Join

This MSAccess tutorial explains how to create a query using a LEFT JOIN in Access 2003 (with screenshots and step-by-step instructions).

www.techonthenet.com

 

[Pat Hartman]

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.

What is A Venn Diagram with Examples | EdrawMax Online

The article will cover what is a Venn diagram, Venn diagram examples, and way to make Venn diagram online. Keep reading.

www.edrawmax.com