Oracle join tables

[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, *
from (select ccgw_log.*, ccgw_msg_xmldata.*
      from ccgw_log, ccgw_msg_xmldata
      where ccgw_log.log_id = ccgw_msg_xmldata.log_id)
where rownum < 10

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');

[/quote]
which log_id is connecting to which log_id, try prefixing log_id with the table_name.