> SELECT * from table1
> FK JOIN table2
What if table1 has been joined in twice, to what table alias is table2 joined against?
Example:
SELECT * FROM table1 a
CROSS JOIN table1 b
FK JOIN table2
Would table2 be joined against "b" or "a"?
I would guess "b" and guess the idea is to always let FK JOIN join against the previous join?