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
t(5) unsigned | | | 0 | | | member_id_editor | smallint(5) unsigned | | | 0 | | | updatehistory_details | text | | | | | ++--+--+-+-+ > - Original Message ----- > From: "

Re: Need help forming SQL query

2005-01-20 Thread Rhino
ple can envision the data clearly with only the column names. Rhino - Original Message - From: "Mike Zornek" <[EMAIL PROTECTED]> To: Sent: Thursday, January 20, 2005 11:01 AM Subject: Need help forming SQL query > I have the following query which will get me all of

Need help forming SQL query

2005-01-20 Thread Mike Zornek
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_standing != "Dropped" ORDER BY email.email_address I also have a query which will get me