Ok, this is good:
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 LIMIT 1;
umm... how do I specify which "one"? (this sounds really "slow-poke" to me, sorry.)
I don't mean to be facetious... but *you* tell *us*!
Which row do you want retrieved? You're saying that you just want one, yet your query as it stands specifies a group of rows. You need to decide on selection criteria that will result in a single row's retrieval. If you're having trouble converting that from English to SQL, post it here in English and we will help... but it's a simple matter of taking the extra condition(s) and using AND to combine it or them with what you already have, probably removing the LIMIT. (The LIMIT is correct if you want a single row but don't care which one it is, but from your elaboration that is not the case.)
Bruce Feist
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
