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: <mysql@lists.mysql.com> > 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]