MySQL Forums
Forum List  »  Newbie

help plzzzzzzzz .........querying from two mysql databases
Posted by: binu nibu
Date: January 17, 2008 04:22PM


i am new to mysql and my problemis

There are two databases , say [db01 , db02] in one server and use same connections.

tbl01 - is a table @ db01.
tbl02 - is a table @ db02.

Table tbl01 has 4 fields. (say userID, name, age, place)
Table tbl02 has 4 fileds. (say userID, jobID, job, company)

userID is unique in both tables.
and what i need is to select name and age from tbl01 and job and company from tbl02 with same userID


Options: ReplyQuote

Written By
help plzzzzzzzz .........querying from two mysql databases
January 17, 2008 04:22PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.