[thelist] Joining tables... in MySQL

[Sarah Adams]

> I want to list all job types, and IF there's any corresponding with
> the jobs table, I want to marry them up.
> 
> I've used this:
> 
> 	SELECT jobType.name, jobs.user, jobs.jobNo, jobs.jobType, jobs.hours, jobs.day
> 	FROM jobType
> 	RIGHT JOIN jobs on
> 	jobs.jobType = jobType.id
> 
> But I'm only getting results if there's the Jobtype id in the jobs table..

I think what you need is "LEFT JOIN" instead of "RIGHT JOIN".

-- 
sarah adams
web developer & programmer
portfolio: http://sarah.designshift.com
blog: http://hardedge.ca