Results 1 to 3 of 3
Thread: query from 3 tables in 1
Dec 11, 2009, 14:31 #1
- Join Date
- Apr 2004
- 0 Post(s)
- 0 Thread(s)
query from 3 tables in 1
I am trying to query specific information from 3 tables, the only relationship in the data is that it was selected from the same form.
here is my table info
columns: cityID, cityName, cityState
columns: userID, userName, userEmail
columns: jobID, jobName, jobStart
Individually the queries would be:
select cityName from cities where cityID = '1'
select userName, userEmail from users where userID = '53'
select jobName from jobs where jobID='2'
Is there a way to combine these into one query?
I will be displaying the results back using PHP.