Join two mysql tables

Question

I have two databases - one for articles and the another for the articles' meta information (Like author, date, category and atc.). I have the following columns in meta table: ID, article id, meta type and meta value. I wonder how can I join these two tables to get both - article and meta information - with one mysql query. The article id isn't unique in meta table, that is why I can't figure out how to access specific meta type and according value for the article.

Answer 1

SELECT * FROM articletable RIGHT OUTER JOIN metatable ON articletable.id=metatable.article_id

Answer 2

SELECT * FROM article_table RIGHT JOIN meta_table ON article_table.article_id = meta_table.article_id;

You get repeats from the article table, but it gets all the meta data in a single query. I believe otherwise you need to use multiple.

Answer 3

If what these guys said works for you, then take it, but your wording makes me think that its set up as two different databases with these tables inside of them. If this is the case, then read on.

Assuming the two databases are on the same server and mysql install, this link should help. Ran into this awhile ago, but my databases were on different servers >.<

http://www.shawnhogan.com/2005/12/cross-database-join-with-mysql.html