in reply to Re: Re: SQL JOINs vs WHERE statements
in thread SQL JOINs vs WHERE statements

(Warning: possible duplicate posting)

Yes indeed, but the "comma" is really only a join in disguise:

INNER JOIN and , (comma) are semantically equivalent. Both do a full join between the tables used. Normally, you specify how the tables should be linked in the WHERE condition. MySQL manual

CountZero

"If you have four groups working on a compiler, you'll get a 4-pass compiler." - Conway's Law

  • Comment on Re: Re: Re: SQL JOINs vs WHERE statements