Hi to everybody,
I would like to know if it’s possible to do this in MSAccess SQL:
Select *
FROM (table1 LEFT JOIN table2 ON table1.field1 = table2.field1) LEFT JOIN table2 ON table1.field2 = table2.field1
Note that table2 is being used twice, on each LEFT JOIN.
When I try this on MSAccess SQL view, it gives me an error. Is there any other way to do it? I did it using two separate queries, but I would like to know if it’s possible to do it on one.
Thanks in advance for the help.
