1. Does it matter what order I join them in? (ie is SmallTableOne.Record = LargeTable.Record the same as LargeTable.Record = SmallTableOne.Record?)
2. Is this the correct Join to use?
Code: Select all
FROM `LargeTable`
LEFT JOIN (
`SmallTableOne` , `SmallTableTwo` , `SmallTableThree`
) ON (
SmallTableOne.Record = LargeTable.Record
AND SmallTableTwo.Record = LargeTable.Record
AND SmallTableThree.Record = LargeTable.Record )