make connection 2 database in cs-cart with join in the each table

Question

I'm in confuse how to connection 2 database and make relation it using cs-cart.com is there a way to connected and relate it with code ? if been looking for better pratice but now where to be found

this is the similar code to connect with additional database but how do i how to make relation to other table in different database?

db_initiate($host, $user, $password, $name, $params = array());

Answer 1

Use database with another prefix. config-local.php setted one connection details for cms. Not two.