SELECT ProductCatalog.*, Review.Rating, Review.ReviewCount, Parent.ParentID FROM ProductCatalog LEFT JOIN ( SELECT PartNum, SUM(Rating) AS Rating, COUNT(ReviewID) AS ReviewCount FROM ProductReview WHERE (Approved = 1) GROUP BY PartNum ) Review On ProductCatalog.PartNum = Review.PartNum LEFT JOIN ( SELECT ParentPartNum AS ParentID FROM ProductCatalog WHERE (ParentPartNum IS NOT NULL) GROUP BY ParentPartNum ) Parent On ProductCatalog.PartNum = Parent.ParentID WHERE ProductCatalog.PartNum = 'LF999' ORDER BY ProductCatalog.PartNum;