Page 1 of 1

Query for 2 Databases?

Posted: Sun Aug 17, 2003 10:14 am
by phppick
Can anybody tell me how write a Query connecting 2 Database tables.
Suppose Database "A" Got table1 and Database "B" got table2. i wnat to get some data by joining these 2 tables.

A.table1 and B.table2

Posted: Sun Aug 17, 2003 10:27 am
by patrikG
There's a nice tutorial about this here.

Posted: Sun Aug 17, 2003 12:00 pm
by nigma
Thanks for the link patrik, I have wondered that myself but didn't know what it was called so searching didn't help me.

Posted: Mon Aug 18, 2003 1:02 am
by derek
SELECT table1.name, table2.grade FROM table1,table2 WHERE table2.marks < 60 AND table1.age = 20 ORDER BY DESC LIMIT 0,1;