SELECT QtyBeginRange, QtyEndRange, UnitPrice, WholesalePrice, b.discounttype, b.discountamount, b.DiscountStartDate, b.DiscountEndDate FROM ProductsPrice a LEFT OUTER JOIN Discounts b on a.productID = b.productID WHERE a.ProductID = #similarproductID#