Join between tables in two different databases?

by

Yes, assuming the account has appropriate permissions you can use:

SELECT <...>
FROM A.table1 t1 JOIN B.table2 t2 ON t2.column2 = t1.column1;

You just need to prefix the table reference with the name of the database it resides in.

More Related Contents:

  1. What’s the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN? [duplicate]
  2. 1052: Column ‘id’ in field list is ambiguous
  3. Join tables with SUM issue in MYSQL
  4. Required to join 2 tables with their FKs in a 3rd table
  5. How can I join multiple SQL tables using the IDs?
  6. Why does MySQL report a syntax error on FULL OUTER JOIN?
  7. Mixing ANSI 1992 JOINs and COMMAs in a query
  8. Cumulative sum over a set of rows in mysql
  9. What’s the difference between comma separated joins and join on syntax in MySQL? [duplicate]
  10. MySQL JOIN the most recent row only?
  11. How to find non-existing data from another Table by JOIN?
  12. MySQL Inner Join Query Multiple Tables
  13. Difference between these two joining table approaches?
  14. Laravel join with 3 Tables
  15. MySQL LEFT JOIN 3 tables
  16. how to use a like with a join in sql?
  17. When to use a left outer join?
  18. In what order are MySQL JOINs evaluated?
  19. How to store a one to many relation in MySQL database?
  20. MySQL Multiple Joins in one query?
  21. SQL Query needed for fetch value from Two identical table but not fully identical table
  22. How to reset AUTO_INCREMENT in MySQL
  23. MySQL Query GROUP BY day / month / year
  24. How to select a column name with a space in MySQL [duplicate]
  25. How do I use on delete cascade in mysql?
  26. Adding a leading zero to some values in column in MySQL
  27. Update one MySQL table with values from another
  28. MySQL Group By and Sum total value of other column
  29. MySQL query, MAX() + GROUP BY
  30. ALTER table – adding AUTOINCREMENT in MySQL

Leave a Comment