Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

multi database query

Status
Not open for further replies.

AlbertH08

Programmer
Mar 28, 2003
1
NL
Is it possible to make a query on the mysql.user table plus any other table from a different database ??

Something like this won't work....

SELECT mysql.user.*, <otherdb>.<table>.*
FROM mysql.user, <otherdb>.<table>
WHERE mysql.user.user = <otherdb>.<table>.<field>
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top