Welcome Guest, Not a member yet? Register   Sign In
Join Logic
#1

[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



Theme © iAndrew 2016 - Forum software by © MyBB