sql - Is it possible to use subquery in join condition in Access ...

SELECT * FROM table1 LEFT JOIN table2 ON table1.id1 = (SELECT ... Join or subquery in MS Access.

stackoverflow.com