• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
join sql help

#3
[eluser]skeletonfriend[/eluser]
You need to have a foreign key in the Catalog table that references the Genre table in order to make a join.

Code:
$this->db->from('catalogo');
$this->db->join('generi', 'catalogo.generi_id = generi.id');
$result = $this->db->get();


Messages In This Thread
join sql help - by El Forum - 06-22-2011, 12:48 PM
join sql help - by El Forum - 06-22-2011, 01:02 PM
join sql help - by El Forum - 06-23-2011, 01:33 AM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2021 MyBB Group.