These two SQL queries return a different number of records. Why?
The 'From Tablen' expression varies depending where I start my join from in the Access expression builder. Why should this make a difference?
SELECT Table1.f4, Table2.f4
FROM Table1 INNER JOIN Table2 ON (Table1.f3 = Table2.f3) AND (Table1.f2 = Table2.f2)
ORDER BY Table1.f4;
SELECT Table1.f4, Table2.f4
FROM Table2 INNER JOIN Table1 ON (Table1.f2 = Table2.f2) AND (Table1.f3 = Table2.f3)
ORDER BY Table1.f4;
Any ideas??
The 'From Tablen' expression varies depending where I start my join from in the Access expression builder. Why should this make a difference?
SELECT Table1.f4, Table2.f4
FROM Table1 INNER JOIN Table2 ON (Table1.f3 = Table2.f3) AND (Table1.f2 = Table2.f2)
ORDER BY Table1.f4;
SELECT Table1.f4, Table2.f4
FROM Table2 INNER JOIN Table1 ON (Table1.f2 = Table2.f2) AND (Table1.f3 = Table2.f3)
ORDER BY Table1.f4;
Any ideas??