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.