select t1.vend_id,count(prod_id)
from Vendors t1
left join Products t2
on t1.vend_id=t2.vend_id
group by t1.vend_id
order by t1.vend_id asc