Problem with JOIN query - 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: Problem with JOIN query (/showthread.php?tid=41586) |
Problem with JOIN query - El Forum - 05-11-2011 [eluser]jvk22[/eluser] I need to make a join query, but I'm not 100% certain how. Two Tables: offer, downloads I need to select all rows in the offer table based on the rules below offer.id != downloads.offer_id downloads.status != 1 downloads.ip = $this->input->ip_address() offer.country = $users_country |