[thelist] Joining tables... in MySQL

[Hassan Schroeder]

On 4/4/07, Jason Handby <jason.handby at corestar.co.uk> wrote:
> > 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.

And performance --

I recently noticed a fairly complex query with a lot of old 'WHERE this
AND WHERE that' was taking over 30 seconds on MySQL 4.1.x.

Reformulating it to use JOIN syntax brought it down under a second :-)

Small sample, YMMV, etc....

-- 
Hassan Schroeder ------------------------ hassan.schroeder at gmail.com