MySQL Lists: mysql: RE: SELECT subquery problem

List:	General Discussion	« Previous Message Next Message »
From:	cl	Date:	February 6 2013 4:30pm
Subject:	RE: SELECT subquery problem
View as plain text

>  You can do:
>  
>  
>  SELECT last_name, first_name, phone, if(pub_email="Y",email,"") as email
>  FROM `mydatabasetable` WHERE `current_member` = "Y" AND `pub_name` = "Y"
>  ORDER BY last_name ASC
>  

Gracias, Carlos. This worked fine!

---Fritz

Thread
• SELECT subquery problem	cl	5 Feb 2013
• RE: SELECT subquery problem	Carlos Eduardo Caldi	5 Feb 2013
• RE: SELECT subquery problem	cl	6 Feb 2013
• Aw: SELECT subquery problem	Stefan Kuhn	5 Feb 2013
• Re: SELECT subquery problem	Andrew Moore	5 Feb 2013
• Re: SELECT subquery problem	Andy Wallace	5 Feb 2013