Need help with query looking at two tables

[DougP]

I would like to show all the matches between [Raw Data All].School and Projects.Company but also show any that don't match. like so
Company School
ABC ABC
DEF
GHI GHI
XYZ ZYZ
TUV

So we did projects for ABC, GHI, XYZ
but not for DEF and TUV, But I would like to see all of them as shown in my example. I would like to see DEF and TUV and have an empty space in the School column.
Is this possible?


SELECT Projects.Company, Projects.[Project Number], Projects.[Project Name], Projects.Facility
FROM [Raw Data All] INNER JOIN Projects ON [Raw Data All].School = Projects.Facility
WHERE (((Projects.Company) Like "the school*") AND ((Projects.[Project Number]) Like "97*") AND ((Projects.[Project Name]) Like "*Triennial*"));


TIA

DougP

 

[PWise]

SELECT Projects.Company, Projects.[Project Number], Projects.[Project Name], Projects.Facility
FROM [Raw Data All] left JOIN Projects ON [Raw Data All].School = Projects.Facility
WHERE (((Projects.Company) Like "the school*") AND ((Projects.[Project Number]) Like "97*") AND ((Projects.[Project Name]) Like "*Triennial*"));

 

[Remou]

It is worth reading:

http://www.devshed.com/c/a/MySQL/Understanding-SQL-Joins/

Try:

SELECT Projects.Company, Projects.[Project Number], Projects.[Project Name], Projects.Facility
FROM Projects LEFT JOIN [Raw Data All] 
ON Projects.Facility=[Raw Data All].School
WHERE (((Projects.Company) Like "the school*") 
AND ((Projects.[Project Number]) Like "97*") 
AND ((Projects.[Project Name]) Like "*Triennial*"));