Join Logic

Join Logic

05-23-2012, 03:37 PM

[eluser]usefulidiot[/eluser]

Code:
SELECT *

FROM events

JOIN users ON events.user_id = users.id

JOIN colleges ON events.college_id = colleges.id

WHERE events.user_id = 1

Messages In This Thread

Join Logic - by El Forum - 05-23-2012, 02:24 PM

Join Logic - by El Forum - 05-23-2012, 03:36 PM

Join Logic - by El Forum - 05-23-2012, 03:37 PM

Join Logic - by El Forum - 05-23-2012, 04:00 PM

Join Logic - by El Forum - 05-23-2012, 05:46 PM

Join Logic - by El Forum - 05-23-2012, 06:32 PM

Join Logic - by El Forum - 05-23-2012, 06:45 PM

Join Logic - by El Forum - 05-23-2012, 07:05 PM

Join Logic - by El Forum - 05-23-2012, 07:19 PM