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