Multiple table queries

[brett]

Hi
I am trying to figure out a way to write a multiple table query without having to specify every record to return. Here is what I have now.

$resultID = mysql_query("SELECT * FROM jobs WHERE jobNum = $jobNum ORDER BY jobNum", $linkID) or die(mysql_error());

Is there a way that I can a seperate table to SELECT * from? The two tables I need data out of are jobs and property. One of the records returned from the jobs table is $prop and that is the variable that I want to query the property table with.

I don't want to have to write out evey record like

$resultID = mysql_query("SELECT jobs.prop, jobs.jobNum, property.propMain, property.state........ you get the picture.

I have about 20 records returning from the jobs table... I guess I am just lazy.
Any ideas?
Thanks
Brett

[theeper]

Sounds like you need subselects. AFAIK MySQL does not natively support subselects.

[shu]

Can you just join the two tables?

$query = "SELECT a.,b. FROM jobs a, property b WHERE a.prop=b.prop AND a.jobNum=$jobNum ORDER BY a.jobNum";

[brett]

Thanks for your help. I was able to get it to work.