CodeIgniter Forums
JOIN query problem - 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: JOIN query problem (/showthread.php?tid=18953)



JOIN query problem - El Forum - 05-23-2009

[eluser]vps4[/eluser]
I using SQLITE database

when I do this
Code:
$this->db->select('article.ID, article.node_ID, article.title, node.node_title');
            $this->db->from('article');
            $this->db->join('node', 'node.node_ID = article.ID');
            $this->db->limit(1);
            $query = $this->db->get();

it give me an error:

Code:
A Database Error Occurred
Error Number: 1

SQL logic error or missing database

SELECT article.ID, article.node_ID, article.title, node.node_title FROM (article) JOIN node ON node.node_ID = article.ID LIMIT 1

how can I fix it?


JOIN query problem - El Forum - 05-23-2009

[eluser]geocine[/eluser]
Try this:

Code:
$this->db->select('*');
            $this->db->from('article');
            $this->db->join('node', 'node.node_ID = article.ID');
            $this->db->limit(1);
            $query = $this->db->get();

and see what you get.