Re: Need help forming SQL query

2005-01-20 Thread Rhino
; <[EMAIL PROTECTED]> To: "MySQL" Cc: "Rhino" <[EMAIL PROTECTED]> Sent: Thursday, January 20, 2005 11:26 AM Subject: Re: Need help forming SQL query > On 1/20/05 11:16 AM, "Rhino" <[EMAIL PROTECTED]> wrote: > > > You should *ALWAYS* in

Re: Need help forming SQL query

2005-01-20 Thread SGreen
Mike Zornek <[EMAIL PROTECTED]> wrote on 01/20/2005 11:01:38 AM: > I have the following query which will get me all of the emails for my > current membership: > > SELECT email.email_address > FROM member, email > WHERE > member.member_primary_email_id = email.email_id > AND member.member_standin

Re: Need help forming SQL query

2005-01-20 Thread Mike Zornek
On 1/20/05 11:16 AM, "Rhino" <[EMAIL PROTECTED]> wrote: > You should *ALWAYS* indicate which version of MySQL you are using when you > ask this sort of question; the answers is almost always "it depends: if you > are using 3.x, do X, if you are using 4.0.x do Y, if you are using 4.1.x do > Z". It'

Re: Need help forming SQL query

2005-01-20 Thread Rhino
You should *ALWAYS* indicate which version of MySQL you are using when you ask this sort of question; the answers is almost always "it depends: if you are using 3.x, do X, if you are using 4.0.x do Y, if you are using 4.1.x do Z". It's a lot of work to list all of those options and most people won'