Join databases

[Jacqueline]

Hello, I am trying to link two databases in order to get values from tables of two databases using query builder. For example, I join Table X and Y. I need a column in table X to provide the values for two columns in table Y. But as I run the query I can get the value of only one coumn at a time. Is this function possible via query buider or do I type the SQL statement manually? Kindle assist.