[thelist] Joining tables... in MySQL

Jason Handby jason.handby at corestar.co.uk
Wed Apr 4 09:19:20 CDT 2007

> 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.


More information about the thelist mailing list