Welcome Guest, Not a member yet? Register   Sign In
Oracle join tables
#1

[eluser]atomp3[/eluser]
Hi

I'm trying to execute query on CI and Oracle

Code:
$this->db->select('*');
    $this->db->from('CCGW_LOG');
    $this->db->join('CCGW_MSG_XMLDATA', 'LOG_ID = LOG_ID');
    $this->db->limit(10);
    
    $query = $this->db->get();
    
    return $query->result_array();

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


Messages In This Thread
Oracle join tables - by El Forum - 02-23-2009, 07:05 AM
Oracle join tables - by El Forum - 02-24-2009, 05:14 PM



Theme © iAndrew 2016 - Forum software by © MyBB