Oracle join tables - Printable Version +- CodeIgniter Forums (https://forum.codeigniter.com) +-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20) +--- Forum: Archived General Discussion (https://forum.codeigniter.com/forumdisplay.php?fid=21) +--- Thread: Oracle join tables (/showthread.php?tid=16040) |
Oracle join tables - El Forum - 02-23-2009 [eluser]atomp3[/eluser] Hi I'm trying to execute query on CI and Oracle Code: $this->db->select('*'); but getting error: Call to a member function result_array() on error TRUE: SELECT * FROM (select inner_query.*, rownum rnum FROM (SELECT * FROM "CCGW_LOG" JOIN "CCGW_MSG_XMLDATA" ON "LOG_ID" = "LOG_ID" ) inner_query WHERE rownum < 10) When comment: Code: $this->db->join('CCGW_MSG_XMLDATA', 'LOG_ID = LOG_ID'); query executing fine. How to use join tables with Oracle? Thanks for help Oracle join tables - El Forum - 02-24-2009 [eluser]Relexx[/eluser] [quote author="atomp3" date="1235415931"]SELECT * FROM (select inner_query.*, rownum rnum FROM (SELECT * FROM "CCGW_LOG" JOIN "CCGW_MSG_XMLDATA" ON "LOG_ID" = "LOG_ID" ) inner_query WHERE rownum < 10) [/quote] Traditionally Oracle table joins are in there where clause. Code: select rownum, * having said all that this like could be your problem [quote author="atomp3" date="1235415931"] Code: $this->db->join('CCGW_MSG_XMLDATA', 'LOG_ID = LOG_ID'); which log_id is connecting to which log_id, try prefixing log_id with the table_name. |