CodeIgniter Forums
[ASK] Query Data using Oracle. Working on Navicat, doesn't work on CodeIgniter - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forum-20.html)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forum-23.html)
+--- Thread: [ASK] Query Data using Oracle. Working on Navicat, doesn't work on CodeIgniter (/thread-60181.html)



[ASK] Query Data using Oracle. Working on Navicat, doesn't work on CodeIgniter - El Forum - 02-01-2014

[eluser]Unknown[/eluser]
Hi..
I have a problem with CodeIgniter when I select multiple table using $this->db->query(); First, I made the query using Navicat for Oracle, and it works. But when I put the query into $this->db->query(); I got an error like I got in the second picture.

workin' on Navicat
<img src="https://fbcdn-sphotos-f-a.akamaihd.net/hphotos-ak-prn2/t1/q71/1560665_257629487737027_445594976_n.jpg">


doesn't work on CodeIgniter
<img src="https://fbcdn-sphotos-h-a.akamaihd.net/hphotos-ak-prn1/t1/q71/s720x720/1551617_257629501070359_831779571_n.jpg">

So, I tried to modify the query into selecting only a single table. And, BOOM! It works. So I though the problem is in the way I join the table. But let's see, I got the query works in Navicat.

and I change into selecting only a single table, it works -_-
<img src="https://fbcdn-sphotos-b-a.akamaihd.net/hphotos-ak-ash3/t1/q71/s720x720/1010781_257629507737025_702287803_n.jpg">

Does anyone ever had the same problem? Thank you so much.