'Multiple databases in a Single Select Statement - RDS Mysql

appreciate some help here please:

Is it possible to write a SQL statement to retrieve data from 2 separate databases belonging to 2 separate RDS instances, in a single SQL ?

Like can we have the 2 RDS connected somehow together

Example:

SELECT * FROM DATABASE_A.TABLE_1 WHERE (SELECT * FROM DATABASE_B.TABLE_2)

assume DATABASE_A is the database on RDS 1 & assume DATABASE_B is the database on RDS 2

Thank you

mysql database

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source