Forums

The forums ran from 2008-2020 and are now closed and viewable here as an archive.

Home › Forums › Back End › Combines two or more `SELECT * from` together? › Re: Combines two or more `SELECT * from` together?

October 18, 2011 at 7:24 am #89222
SgtLegend
Member

See how this goes for you

$query = $this->db->query('SELECT geo.order FROM Store_Information si LEFT JOIN Geography AS geo ON geo.id = si.id WHERE si.name LIKE "%' . $find1 . '%"');