• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
JOIN query problem

#1
[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?


Messages In This Thread
JOIN query problem - by El Forum - 05-23-2009, 09:50 AM
JOIN query problem - by El Forum - 05-23-2009, 08:17 PM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


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