SELECT units.*, projects.project_name, locations.detail as location_detail 
                          FROM units
                          LEFT JOIN projects on (projects.id = units.project_id)
                          LEFT JOIN locations on (projects.location = locations.id)
                          WHERE units.id != 0  AND units.id = 38