[thelist] Joining tables... in MySQL

[Jason Handby]

> SELECT * FROM jobType, jobs WHERE jobType.id = jobs.jobType
> 
> /me doesn't understand why so many people try to force themselves into
> left/inner/right joins when you can just say "where this is that"

Because this join syntax is incredibly out of date, and there are things
you can't express in it. Much better to get into the habit of using the
"new" syntax.



J