select *,(select count(*) from prod1 where procategory1 = cstr(prodcategory.idno) ) as prodcount from prodcategory where idno = 2
Arrow L Arrow R