Hi Bruce, tlr7425 and MySQl List,
2003年 6月 26日 木曜日 10:25、Nils Valentin さんは書きました: > 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 I double checked it. Bruce is correct - I am the looser ;-). I mistook the INNER JOIN. My appologize for that. All credits to Bruce. Please ignore my posting for this topic. Thank you for pointing this out. Best regards Nils Valentin Tokyo/Japan > > -- > --- > Valentin Nils > Internet Technology > > E-Mail: [EMAIL PROTECTED] > URL: http://www.knowd.co.jp > Personal URL: http://www.knowd.co.jp/staff/nils -- --- 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]
