Showing values that don't exist...

[Jbozward]

This may be simple, but I just can't get it to work!!

I have 2 tables;

a) A list of standard document tiltles
b) A list of documents for a project

There are 20 standard documents titles in table a) which never changes, and there are only 10 of them in done so far in b).

If i make a query to show all records in a) and only those that match in b), I only see 10 records.

I would like to be able to see all 20 in a) with either data from b) or blank if it's missing.

I have tried with and without joins and am now stumped!!!

 

[ggreg]

SELECT Table1.id, Table1.test, Table2.tt, Table2.aa, Table1.ID1
FROM Table1 LEFT JOIN Table2 ON Table1.test = Table2.tt;

Table 1 is your A and table 2 is your b

you need to in the join properties say you want all records
from table 1 and just the records from table 2 where the
records are equal