John Davidson

Message:

Currently i can connect to multiple database in 1 application ci 4 using $DBGroup in model, but is it possible to select 2 tables in different databases?

ex: table users in default_db and table products in another_Db

protected $DBGroup = 'default_db';



public function user_product(){

        $sQuery = "SELECT users.id, users.name, users.email, users.phone, products.id, products.name, products.price FROM users INNER JOIN products ON users.id = products.user_id";

            

        $query = $this->db->query($sQuery);         

            

        return $query;

}

---

My Answer:
"SELECT u.*, p.* FROM default_db.users u JOIN another_Db.products p ON u.user_id = p.user_id";