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]