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]
