Multi Database Select

[admin]

Hi there,

haven't found any info here and in the mysql doc
about selecting (joining) from tables of multiple databases.

Here is what I want to do:
- CORE-System has database A table user...
- App B has: database B table customers
- App C has: database C table personell
and so on with more APPs (all feeded from the CORE-System)

Now I want to join like
SELECT * from A.user, B.custumer
WHERE A.user.id = B.customer.userid

so all the apps can rely on one CORE-user management in a different DB.

Any ideas?

Thanks,
Sven