Select
x1.Company as Company,
x1.Product as Product,
x1.Rec_Company as Rec_Company,
Count(x1.Rec_Company) as Rec_count,
x2.Product as Product2,
x2.Rec_Company as Rec_Company2,
Count(x2.Rec_Company) as count
From Tbl_name x1,Tbl_name x2
where
x1.company=x2.company and
x1.product is not null and
x1.Rec_Company is not null
or x2.product is null


Am not sure....try this