MySQL Forums :: Newbie :: Help with query with conditions


Advanced Search

Help with query with conditions
Posted by: Aaron Nicolais ()
Date: February 03, 2010 08:49AM

Hi,
I am trying to run the following query. In this query it shows all contacts with an email address but does not show the ones without an email address. This is because of the second to last line "AND contacts.id = email_addr_bean_rel.bean_id". What I need is to run all the lines except this one. Then also run all the lines with this one and put the 2 pieces of data together so I have the contacts with and without email addresses. Is there a way to do this with some sort of case/if statement or what would be the best way to go about this? I am doing this right from a command line.

Thanks!

accounts_cstm.result_status_date_c,accounts_cstm.Listsource_c, accounts_cstm.product_interest_c,accounts.name,contacts.first_name,contacts.last_name, contacts.title,contacts.phone_work, email_addresses.email_address, contacts.primary_address_street,contacts.primary_address_city, contacts.primary_address_state, contacts.primary_address_postalcode,primary_address_country,notes.description
FROM notes, accounts, accounts_cstm, contacts, accounts_contacts,email_addr_bean_rel, email_addresses
WHERE accounts.id = accounts_cstm.id_c
AND accounts_contacts.contact_id = contacts.id
AND accounts_contacts.account_id = accounts.id
AND notes.contact_id = contacts.id
AND accounts_cstm.result_status_c LIKE 'Qualified Lead%'
AND contacts.id = email_addr_bean_rel.bean_id
GROUP BY contacts.last_name

Options: ReplyQuote


Subject Written By Posted
Help with query with conditions Aaron Nicolais 02/03/2010 08:49AM
Re: Help with query with conditions Rick James 02/05/2010 10:58AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.