Hi Bruce; I havent read Pauls book, but I will try to make an sample, also to confirm for myself what I stated before.
I will come back to it once more. I am not sure if I should create a now post for this or continue this threat as it s kind of attached to it. Thank you for your reply. Best regards Nils Valentin Tokyo/Japan 2003年 6月 25日 水曜日 22:09、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 -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
