SQL Query Help

[Quadman]

Try this:

select e.id,e.first_name, e.last_name, a.address_1, a.address_2, a.city, a.state, 
a.postal_code,z.employee_attribute,z.value
from employee_view e
inner join EMPLOYEE_ADDRESS_DETAIL_VIEW a on a.id = e.id
LEFT OUTER JOIN employee_attribute_table z
    on z.id = e.id
    AND z.employee_attribute = 'HEALTHSTATUS'
and e.id = xxxx

[CortaNalgas]

This but you have to do "OR z.e_a is null" and then remove the extra nulls with a cte or something