Código SQL [-] select tipo, apellido as nombre from tabla where tipo = 1 union select tipo, razonsocial as nombre from tabla where tipo = 2
select tipo, apellido as nombre from tabla where tipo = 1 union select tipo, razonsocial as nombre from tabla where tipo = 2