help with a multiple select

[nozom]

I'm not very good with my multiple selects, need a little help on this one so. I have 4 tables

main one is joblistings and this contains job information as well as ID keys which relate to the location and the work type

my select looks like this but has issues ;-)
the $_SESSION vars are the results of a search which passes the location ID and the worktype ID.

$result=mysql_query("SELECT * FROM joblisting, locations, work_type WHERE
joblisting.Location_ID=locations.Location_ID AND
 joblisting.Worktype_ID=work_type.Type_ID AND 
joblisting.Location_ID LIKE $_SESSION[locations] AND
joblisting.Worktype_ID LIKE $_SESSION[worktype] ");

Any help would be appreciated.

Thanks,
nozom

[TTT]

don't see any reason to use LIKE

$result=mysql_query("
SELECT * 
FROM joblisting jl INNER JOIN locations lo ON
jl.Location_ID=lo.Location_ID INNER JOIN work_type wt ON  jl.Worktype_ID=wt.Type_ID 
WHERE jl.Location_ID = $_SESSION[locations] AND 
jl.Worktype_ID = $_SESSION[worktype] ");