List:General Discussion« Previous MessageNext 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 problemcl5 Feb
  • RE: SELECT subquery problemCarlos Eduardo Caldi5 Feb
    • RE: SELECT subquery problemcl6 Feb
  • Aw: SELECT subquery problemStefan Kuhn5 Feb
    • Re: SELECT subquery problemAndrew Moore5 Feb
  • Re: SELECT subquery problemAndy Wallace5 Feb