SELECT a.*, b.*, (a.Texto || b.Tipo) as TextoTipo FROM TABLA_PRINCIPAL a LEFT OUTER JOIN TABLA_Rango b ON a.id_Rango = b.id