-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 27 Jun 2003 02:49:21 -0400, [EMAIL PROTECTED] wrote:
>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
[EMAIL PROTECTED] wrote:
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
On Friday, June 27, 2003, at 02:14 AM, James Moe wrote:
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
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
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".
- --
SELECT
LIMIT 1;
- Original Message -
From: <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Friday, June 27, 2003 1:08 PM
Subject: SELECT single record
Thanks everybody for all you great help!
Ok, this statement will select al
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 specif
At 01:08 AM 6/27/2003 -0400, [EMAIL PROTECTED] wrote:
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 peop
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
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 =
mod
