Query Supplier.SupplierGLAccountId

select [DBId], count(*) from [Supplier] where [SupplierGLAccountId] = 0 or [SupplierGLAccountId] is null group by [DBId]