Erm, the first sql as i can see doesn't connect on the same field as the second one that produces the correct result. George Christoforakis
----- Original Message ----- From: <[EMAIL PROTECTED]> To: "MySQL List" <[EMAIL PROTECTED]> Sent: Wednesday, June 25, 2003 9:01 AM Subject: Join vs. Where (help) > This: > > SELECT * FROM machines INNER JOIN people ON > machines.machinesID=people.peopleID; > > Is not producing the same results as this: > > SELECT lastname, model FROM people, machines WHERE machines.peopleID = > people.peopleID; > > Can someone please tell why, what's wrong? > > (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 > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]