n | 273 |
| 204 | Millet| David | 302 |
+-+---+-+---+
-Original Message-
From: Dean Householder [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 19, 2002 2:53 PM
To: Roger Karnouk; [EMAIL PROTECTED]
Subject: Re: basic query question
ED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, February 19, 2002 1:04 PM
Subject: RE: basic query question
You're very close:
mysql> select p1.lname, p1.fname, p2.lname as engaged_lname, p2.fname as
engaged_fname from members p1, members p2 where p1.id = p2.engagedto;
but the REAL questio
der [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 19, 2002 1:53 PM
To: Roger Karnouk; [EMAIL PROTECTED]
Subject: Re: basic query question
Okay, so I do this and all I end up with is
+-+---+-+---+
| id | lname | fname
ECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, February 19, 2002 12:17 PM
Subject: RE: basic query question
you will have to join the table with itself
and reference it as if it is two tables.
this might be slow however so you might want to make some
specific indexes to speed it up.
This Que
PROTECTED]]
Sent: Tuesday, February 19, 2002 12:22 PM
To: [EMAIL PROTECTED]
Subject: basic query question
I'm fairly new to MySQL, so if anyone could help me I'd really appreciate
it!
What I'm trying to do is join two pictures in a database to each other. My
database holds info ab
: [EMAIL PROTECTED]
Subject: Re: basic query question
At 19.02.2002 10:22, you wrote:
>I'm fairly new to MySQL, so if anyone could help me I'd really appreciate
>it!
>
>What I'm trying to do is join two pictures in a database to each other. My
>database holds i
]
Subject: basic query question
I'm fairly new to MySQL, so if anyone could help me I'd really appreciate
it!
What I'm trying to do is join two pictures in a database to each other. My
database holds info about people with variables:
id, lname, fname, engagedto, pic
The engagedto fie
At 19.02.2002 10:22, you wrote:
>I'm fairly new to MySQL, so if anyone could help me I'd really appreciate
>it!
>
>What I'm trying to do is join two pictures in a database to each other. My
>database holds info about people with variables:
>
>id, lname, fname, engagedto, pic
Try this, even if I´
I'm fairly new to MySQL, so if anyone could help me I'd really appreciate
it!
What I'm trying to do is join two pictures in a database to each other. My
database holds info about people with variables:
id, lname, fname, engagedto, pic
The engagedto field contains the id of the person they are