Join

[Jonas Bergman]

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

[Lothar Haensler]

syntax goes something like that:

SELECT * FROM firsttable LEFT JOIN secondtable ON firsttable.keyfield = secondtable.keyfield