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's a lot of work to list all of those options and most people won't do
> it.
>
> It would also help if you provided information about what columns occurred
> in each table so that potential responders are clear on what information is
> in each of your tables. Including a few typical sample rows is also very
> helpful for some of us, although some people can envision the data clearly
> with only the column names.
>
> Rhino
Ok, noted. I'll include this info with any future questions.
i'm using MySQL 4.0.17-log
Email:
+---------------+----------------------+------+-----+---------+-------------
---+
| Field | Type | Null | Key | Default | Extra
|
+---------------+----------------------+------+-----+---------+-------------
---+
| email_id | smallint(5) unsigned | | PRI | NULL |
auto_increment |
| email_type | enum('Home','Work') | | | Work |
|
| email_address | varchar(50) | | UNI | |
|
| member_id | smallint(5) unsigned | | MUL | 0 |
|
| email_private | tinyint(1) | | | 0 |
|
+---------------+----------------------+------+-----+---------+-------------
Update History:
+------------------------+----------------------+------+-----+---------+----
------------+
| Field | Type | Null | Key | Default |
Extra |
+------------------------+----------------------+------+-----+---------+----
------------+
| updatehistroy_id | smallint(5) unsigned | | PRI | NULL |
auto_increment |
| updatehistroy_datetime | datetime | YES | | NULL |
|
| member_id_edited | smallint(5) unsigned | | | 0 |
|
| member_id_editor | smallint(5) unsigned | | | 0 |
|
| updatehistory_details | text | | | |
|
+------------------------+----------------------+------+-----+---------+----
> ----- Original Message -----
> From: "Mike Zornek" <[EMAIL PROTECTED]>
> To: <[email protected]>
> 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 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 the email addresses of anyone who
> has
>> updated their profile (and thus has a row in updatehistory)
>>
>> SELECT DISTINCT email.email_address
>> FROM member, email, updatehistory
>> WHERE
>> member.member_primary_email_id = email.email_id
>> AND member.member_standing != "Dropped"
>> AND member.member_id = updatehistory.member_id_editor
>> ORDER BY email.email_address;
>>
>> How would I get the emails for every member who does NOT have a row in
>> updatehistory?
>>
>> ~ Mike
>> -----
>> Mike Zornek
>> Web Designer, Media Developer, Programmer and Geek
>> Personal site: <http://MikeZornek.com>
>>
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>>
>>
>>
>> --
>> No virus found in this incoming message.
>> Checked by AVG Anti-Virus.
>> Version: 7.0.300 / Virus Database: 265.7.0 - Release Date: 17/01/2005
>>
>>
>
>
~ Mike
-----
Mike Zornek
Web Designer, Media Developer, Programmer and Geek
Personal site: <http://MikeZornek.com>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
