Welcome Guest, Not a member yet? Register   Sign In
Need help with many to many table join.
#2

[eluser]seanloving[/eluser]
[quote author="Ichabodcole" date="1272683750"]
Code:
/* Now I have no idea how to join the project_credit_list with the project_credits table and then to the projects*/
        //$this->db->join('project_credit_list', 'project_credit_list.project_id = projects.id', 'left');
[/quote]
maybe try something like this
Code:
->join('project_credit_list', 'project_credit_list.project_id = projects.id AND project_credit_list.project_credit_id = project_credits.id', 'left')


Messages In This Thread
Need help with many to many table join. - by El Forum - 04-30-2010, 04:15 PM
Need help with many to many table join. - by El Forum - 04-30-2010, 06:43 PM
Need help with many to many table join. - by El Forum - 05-01-2010, 06:28 PM



Theme © iAndrew 2016 - Forum software by © MyBB