TalkPHP - View Single Post

xenon · 02-09-2008, 09:42 PM

leftmost - the table you're joining first
rightmost - the table you're joining last

If you look at a query, you'll see that I referred to them by the position in the query.

Code:

SELECT m.*, n.*, k.* FROM table1 m LEFT JOIN table2 n LEFT JOIN table3 k

02-09-2008, 09:42 PM	#7 (permalink)
xenon The Frequenter Join Date: Dec 2007 Location: Bucharest, Romania Posts: 438 Thanks: 3	leftmost - the table you're joining first rightmost - the table you're joining last If you look at a query, you'll see that I referred to them by the position in the query. Code: SELECT m., n., k.* FROM table1 m LEFT JOIN table2 n LEFT JOIN table3 k __________________ I have optimistic thoughts, even though sometimes (if not always) life's a bitch.