making a select on 2 diffrent DB

[pelegk2]

i have 2 diffrent DB
1 calles prod an have a table that called user
and another db called com with a table called users
and i want to check which user appear on them both!
is it possible to do it?
thnaksi nadvance
peleg

[devinemke]

Originally posted by pelegk2
is it possible to do it?

sure, simply select one db, do your query, then select other