Joining Joined Tables - Printable Version +- CodeIgniter Forums (https://forum.codeigniter.com) +-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20) +--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23) +--- Thread: Joining Joined Tables (/showthread.php?tid=61232) |
Joining Joined Tables - El Forum - 10-27-2014 [eluser]Unknown[/eluser] I am stuck in generating SQL statement for joining tables. Basically I have 4 tables. And there are 2 tables with foreign key. Table Sequence is connected to Product table and Region Table. And Distribution table is connected to sequence table. Table Products. id | product_desc Table Region. id | region_desc Table Sequence. id | product_id | region_id Table Distributions id | sequence_id | sales | distribution_fee Here's my code Code: $this->db->select('*'); any help is highly appreciated. Thanks. |