Welcome Guest, Not a member yet? Register   Sign In
[ASK] Query Data using Oracle. Working on Navicat, doesn't work on CodeIgniter

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.

Theme © iAndrew 2016 - Forum software by © MyBB