SELECT DISTINCT ProductKits.ProductKitName, ProductKits.ProductKitID, ProductUnits.UnitName, ProductKits.UnitPrice
FROM (ProductKits INNER JOIN KitProducts ON ProductKits.ProductKitID = KitProducts.ProductKitID) INNER JOIN (ProductPages INNER JOIN ProductUnits ON ProductPages.ProductPageID = ProductUnits.ProductPageID) ON KitProducts.ProductUnitID = ProductUnits.ProductUnitID
WHERE (((ProductPages.ProductPageID) = )) AND (ProductKits.LiveYN = 1)
ORDER BY ProductKits.UnitPrice;
SELECT *
FROM ClearanceItems
WHERE ProductUnitID = #productUnits.ProductUnitID#
|
CLEARANCE SALE ITEM! |
#productUnits.UnitName# #productUnits.UnitNote# |
Our Price: #DollarFormat(productUnits.UnitPrice)# Clearance Price: #DollarFormat(clearanceItem.SalePrice)#
|
Our Price: #DollarFormat(productUnits.UnitPrice)# |
|
|
|
SELECT DISTINCT ProductKits.ProductKitName, ProductKits.ProductKitID, ProductUnits.UnitName, ProductKits.UnitPrice
FROM (ProductKits INNER JOIN KitProducts ON ProductKits.ProductKitID = KitProducts.ProductKitID) INNER JOIN (ProductPages INNER JOIN ProductUnits ON ProductPages.ProductPageID = ProductUnits.ProductPageID) ON KitProducts.ProductUnitID = ProductUnits.ProductUnitID
WHERE (((ProductPages.ProductPageID) = ))
ORDER BY ProductKits.UnitPrice DESC;
|