Joining two seperate tables

Joining two seperate tables

El Forum
Guest

02-03-2009, 02:49 PM

[eluser]JayArias[/eluser]
sure,

Code:
$this->db->join('members', 'member_profile.user_id = usr.id');

will basically join "members" with "member_profile" where `id` = `$id` which will pull information on that member from the user tables and the profile tables corresponding to that member's id.

Messages In This Thread

Joining two seperate tables - by El Forum - 01-30-2009, 10:16 AM

Joining two seperate tables - by El Forum - 02-03-2009, 09:31 AM

Joining two seperate tables - by El Forum - 02-03-2009, 01:41 PM

Joining two seperate tables - by El Forum - 02-03-2009, 02:49 PM

Joining two seperate tables - by El Forum - 02-03-2009, 04:15 PM

Joining two seperate tables - by El Forum - 02-03-2009, 04:17 PM