LIMIT 1 "Me fail English? That's unpossible" ###___Archon___###
----- Original Message ----- From: <[EMAIL PROTECTED]> To: "MySQL List" <[EMAIL PROTECTED]> Sent: Friday, June 27, 2003 12:08 PM Subject: SELECT single record > 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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]