In Access, how can I join one Table with a Select Statement, e.g.
Club Left Join (Select...)
instead of first creating one query and joining the table on this query e.g.
Club Left Join Query1
Printable View
In Access, how can I join one Table with a Select Statement, e.g.
Club Left Join (Select...)
instead of first creating one query and joining the table on this query e.g.
Club Left Join Query1
syntax goes something like that:
SELECT * FROM firsttable LEFT JOIN secondtable ON firsttable.keyfield = secondtable.keyfield