Join Logic |
[eluser]ibnclaudius[/eluser]
I`m having problems with a join. Check out the attached image. I want to select all events from the colleges that a certain user id has. The field user_id on events table is the author of the event, not the current user. I want also get the author name and the college username of the event. http://img406.imageshack.us/img406/7195/codeigniter.png How is that possible? |
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
|