I have two databases (MySQL) on two different servers, and one table references a table in the other. However, I am unable to point the reference to a specific column in the remote table for some reason. Can someone help?
SELECT a.foo, b.bar FROM db1.tableA AS a JOIN db2.tableB AS b ON a.something = b.whatever;
This assumes both "databases" are on the same instance of MySQL on the same server. Otherwise, you need to reword the question.