用相同的id链接多个mysql表[重复]

Question

This question already has an answer here:

• PHP/MYSQL Join multiple tables 2 answers
• Joining three tables using MySQL 7 answers

I am trying to do a website where there will be a list of suppliers and clicking on the supplier will show the data of that particular supplier on another page. Currently I am only able to do it with one database.

Is it possible to link multiple database as the other database have other supplier's data such as purchase records?

<?php
include 'config.php'; 
 $connect = mysqli_connect(DB_SERVER,DB_USERNAME,DB_PASSWORD,DB_DATABASE);
$id = $_GET['id'];

$result = mysqli_query($connect,"SELECT * FROM my30_rsl WHERE id = $id");
?>

Let say I want to link another database:

mysqli_query($connect,"SELECT * FROM bought WHERE id = $id");

Note the: The table structure for both database is similar where SupplierName and Company data are the same

</div>