Lefter outer join in schema to enable listing of unreported suppliers