SELECT COUNT(B.BProdID) AS Hits, B.URL, B.Searchterms,P.Sku as Code, Count(O.OrdID) As NumOfSales ,Sum(O.Price) AS Amount , Sum(O.QTY) As QTY
  FROM TblOrder O RIGHT OUTER JOIN 
TblBrowse B       RIGHT OUTER JOIN 
TblProduct P ON COALESCE(B.BProdID,0) = P.PProdID
  ON COALESCE(B.BProdID,0) = COALESCE(O.OProdID,0)
 
  WHERE B.BehaveID = 2
  GROUP BY O.Price,B.BProdID,P.Sku,O.QTY
  ORDER BY Hits DESC

quote:

---

Originally posted by visakh16

SELECT b.NoOfHits,p.SKU AS Code,o.NoOfSales,o.TotalPrice
FROM tblProduct p
INNER JOIN(SELECT OProdID,SUM(Price) AS TotalPrice,SUM(Qty) AS TotalQty,COUNT(OrdID) AS NoOfSales
           FROM tblOrder
           GROUP BY OProdID)o
ON o.OProdID=p.PProdID
INNER JOIN (SELECT BProdID,COUNT(*) AS NoOfHits
           FROM tblOrder
           GROUP BY BProdID)b
ON b.BProdID=p.PProdID

---