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 derfloh 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
Joined
Mar 28, 2003
Messages
1
Location
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