Can I reference a specific column in a remote table (MySQL)? 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? 

Thank you!
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.