Hello,

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

Table: cities
columns: cityID, cityName, cityState

Table: users
columns: userID, userName, userEmail

Table: jobs
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.

Thank You.