Re: Join vs. Where (help)

[Bruce Feist]

Nils Valentin wrote:

SELECT * FROM machines INNER JOIN people ON
       

machines.peopleID=people.peopleID;
         

Inludes NULL records
       

I meant the first statement returns also empty record fields or should I say 
incomplete data records ?
 

Is not producing the same results as this:

SELECT lastname, model FROM people, machines WHERE machines.peopleID
=
people.peopleID;
         

Dosent include NULL records
       

This one doesnt return any entries with incomplete data records (no data in 
them). So if you have an entry for machines.peopleID but not for 
people.peopeID than it wont show up while it does in the first statement.

 

Nils, I disagree.  The INNER JOIN should be completely equivalent to the 
(corrected) "WHERE" version.  This is supported by Paul DuBois's 
"MySQL", second edition, which states that the INNER JOIN is equivalent 
to the comma operator except that it allows and requires the ON clause.  
It is also supported by standard SQL usage in other RDBMSs.

Bruce Feist



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]