: SubIdSELECT * from AffiliateSalesHistory WHERE AffiliateID=1252 AND aff_product_id=12 AND Tier=1 AND TrackDate='11/5/2009'  : SubIdSELECT * from AffiliateSalesHistory WHERE AffiliateID=1252 AND aff_product_id=12 AND Tier=2 AND TrackDate='11/5/2009' SELECT ProductID, [Description] FROM   Product WHERE  Status<>0 and productid=12 ORDER BY Description