>WITH SalesTots AS >( > select count(invnum) as sales_count > from invitems > group by partnum >) >SELECT partmast.partnum, > partmast.title, > partmast.description > ISNULL(partstats.emplviews,0) as Part_Views, > ISNULL(partstats.intviews,0) as Internet_Bids, > ISNULL(salestots.sales_count,0) as sales_count >FROM partmast > LEFT OUTER JOIN partstats > ON partmast.partnum=partstats.partnum > LEFT OUTER JOIN SalesTots > ON partmast.partnum=salestots.partnum >WHERE partmast.partnum='12345' >GROUP BY partnum >ORDER BY partnum >Close
;WITH SalesTots AS >( > select PartNum, count(invnum) as sales_count > from invitems > group by partnum >) >SELECT partmast.partnum, > partmast.title, > partmast.description > ISNULL(partstats.emplviews,0) as Part_Views, > ISNULL(partstats.intviews,0) as Internet_Bids, > ISNULL(salestots.sales_count,0) as sales_count >FROM partmast > LEFT OUTER JOIN partstats > ON partmast.partnum=partstats.partnum > LEFT OUTER JOIN SalesTots > ON partmast.partnum=salestots.partnum >WHERE partmast.partnum='12345' >GROUP BY partnum >ORDER BY partnum