| |||
|
|
|||
|
|
|||
SELECT product.productID AS prodID, productName.productName, product.price, product.image,product.description, productType.productType FROM (productType INNER JOIN productName ON productType.productTypeID = productName.productTypeID) INNER JOIN product ON productName.productNameID = product.productNameID WHERE webDisplay=true AND ExclusiveRange=True ORDER BY price
|
|||