Thanks everybody for all you great help!

Ok, this statement will select all of my records nicely:

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


How do I write it to retrieve only a single record? (I think I'll be a bit dangerous after I know this! ;-)

Thanks,
Ted


-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to