Quick question! Multiple tables

[eluser]kikz4life[/eluser]
what thdls55 saying is you must use join statement to select data from different tables.

Code:

$this->db->join('tablename1 a', 'a.fieldname1=tablename2.fieldname', 'left')
.......
then

select ....