Hmmm. I do not know the recommended way to do it but the way would be something like this (the dirty way):$sql = "SELECT a.*, b.* FROM database1.table1 a LEFT JOIN database2.table2 b ON b.id=a.ass_idWHERE a.status=".$this->_db->quote('A'); return $this->_db->fetchAll($sql);It is basically just a table join between two tables. The SQL output would be something like:SELECT a.*, b.* FROM database1.table1 a LEFT JOIN database2.table2 b ON b.id=a.ass_id WHERE a.STATUS = "A" |