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