| 조회 :
221
작성자 :
easy car insurance q
[ iabuhhr7y2@mail.com ] [ http://rinkontiki.com/WA/easy-car-insurance-quotes-washingto ] |
|
| 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" |
|
| 작성일자 : 2017년 05월 04일 |
|
|