Results 1 to 1 of 1
Thread: Query from multiple MySQL DB
02-27-2003, 12:40 AM #1ramGuest
Kinda a shot in the dark... does anyone know if there is a way to make a query that references tables from multiple databases? I am basically trying to create a table that every image in my site will be stored in and then different parts of the site which are on different DBs will use the image table which is located in the main DB. Can I basically open up two connections to databases and then reference tables as db1.table1 and db2.table2. For example, will SELECT image.image_title, greetings.date FROM db1.image AND db2.greetings WHERE greetings.image_id=image.imageid
Thanks a lot.