use joined view table, add joined view fields to DAL. Ignore NULL and EMPTY values