[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.