Re: Join vs. Where (help) -(I got it!)

[gerald_clark]

In the second query, the server may switch the order of the join, 
producing the same output in different order.
Try adding an ORDER BY to both and see what happens.

[EMAIL PROTECTED] wrote:

Ok, should be this:

SELECT * FROM machines INNER JOIN people ON 
machines.peopleID=people.peopleID;

Ted

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]