>>> 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. Does it make it a bit clearer ? Sorry dont know how to better explain it really. Best regards Nils Valentin Tokyo/Japan 2003年 6月 25日 水曜日 17:[EMAIL PROTECTED] さんは書きました: > What do you mean when you say, in this case, "does not return the NULL > record"? > > I have no records that are completely "NULL" though some records do > have a NULL field or two? > > Thanks, > Ted > > On Wednesday, June 25, 2003, at 02:42 AM, Nils Valentin wrote: > > Hi tlr7425, > > > > Besides what I said in my last e-mail I completely overlooked that > > > >>> SELECT * FROM machines INNER JOIN people ON > >>> machines.machinesID=people.peopleID; > > > > should be > > > > SELECT * FROM machines INNER JOIN people ON > > machines.peopleID=people.peopleID; > > > > Even though my first statement should still remain correct. The > > statement > > above does not return the NULL record while the other one does INNER > > JOIN) > > > > Best regards > > > > Nils Valentin > > Tokyo/Japan > > > > 2003年 6月 25日 水曜日 15:37、Nils Valentin さんは書きました: > >> 2003年 6月 25日 水曜日 15:[EMAIL PROTECTED] さんは書きました: > >>> This: > >>> > >>> SELECT * FROM machines INNER JOIN people ON > >>> machines.machinesID=people.peopleID; > >> > >> Inludes NULL records > >> > >>> Is not producing the same results as this: > >>> > >>> SELECT lastname, model FROM people, machines WHERE machines.peopleID > >>> = > >>> people.peopleID; > >> > >> Dosent include NULL records > >> > >>> Can someone please tell why, what's wrong? > >> > >> Nothing is wrong thats the way it is supposed to be. > >> > >>> (What happens is that the wrong person are listed with the wrong > >>> machine -using the INNER JOIN shown above, the second statement I > >>> listed works as expected, right person with right machine.) > >>> > >>> Thanks in Advance, > >>> Ted Rogers > >> > >> This is a good example which is also described on page 202-203 Michael > >> Kofler Mysql (Edition1 ) > >> > >> Best regards -- --- 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]
