<[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, February 26, 2003 10:56 AM
Subject: Re: Help needed with SQL...
> I've never seen opening a table twice and then doing a join back with
> itself. Am I wording this correctly? Is that how to des
>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, February 26, 2003 5:11 AM
Subject: RE: Help needed with SQL...
On 26-Feb-2003 [EMAIL PROTECTED] wrote:
> Yes , I had use this query statement in my MySQL server,
> But I have a qu
On 26-Feb-2003 [EMAIL PROTECTED] wrote:
> Yes , I had use this query statement in my MySQL server,
> But I have a query about it.
> Why are you use "WHERE a.groupname=b.groupname AND members.id=b.memberid
> AND a.memberid=1"?
> Can you give me a explain or give me a advise!
>
Sure.
mysql> SELE
From: Don Read [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 26, 2003 4:05 PM
To: M Wells
Cc: [EMAIL PROTECTED]
Subject: RE: Help needed with SQL...
On 26-Feb-2003 M Wells wrote:
> Hi All,
>
> I'm having problems creating a query to return a recordset from the
> following
On 26-Feb-2003 M Wells wrote:
> Hi All,
>
> I'm having problems creating a query to return a recordset from the
> following situation:
>
> I have two tables, one which contains member details, and the other
> which contains details re: the groups to which the member belongs.
>
> When a member l
