Re: SELECT single record

[tlr7425]

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.)

Ted

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
========= Kittiphum Worachat wrote:

add keyword limit 1 at the end of your sql like this

select ........ from .... limit 1

Kittiphum Worachat