On Fri, 27 Jun 2003 01:44:53 -0400, [EMAIL PROTECTED] wrote:
umm... how do I specify which "one"? (this sounds really "slow-poke" to me, sorry.)
Use either "people.peopleID = some_specific_ID" or "models.modelID = some_specific_ID".
I'm more embarrassed than usual... posting too much I guess!
I don't understand how to morph the following with your specification:
SELECT firstName, lastName, deptPOS, workPH, homePH, location, model, make, propID, addressIP, OS FROM people, make, models, machines
WHERE people.peopleID = machines.peopleID AND make.makeID = models.makeID AND models.modelID = machines.modelID
...without destroying the relations?
Ted
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]