Re: conditional return of data in SELECT

[Phillip Ward]

Something like this?

select 
  t1.name name
, case 
  when t2.town_name is not null then t2.town_name
  else t1.town 
  end town
from      table1 t1 
left join table2 t2 
     on   t1.town = t2.town_actual 

+------+-----------+
| name | town      |
+------+-----------+
| Ed   | Boston    |
| Mike | Newton    |
| Dave | Malden    |
| Erin | Haverhill |
+------+-----------+

Regards, Phill W.