 |
|
SELECT
dbo.Product.ID,
dbo.Product.Item_Number,
dbo.Product.Item_Name,
dbo.Product.ShortDescription,
dbo.Product.LongDescription,
dbo.Product.Amount,
dbo.Product.Image,
dbo.Product.Image1,
dbo.Product.Image2,
dbo.Product.Image3,
dbo.Product.Image4,
dbo.Product.SpecSheet,
dbo.Product.CategoryID,
dbo.Category.Name,
dbo.Vendor.Name,
dbo.Section.Name
FROM dbo.Product
INNER JOIN dbo.Vendor
ON dbo.Product.VendorID = dbo.Vendor.ID
INNER JOIN dbo.Category
ON dbo.Product.CategoryID = dbo.Category.ID
INNER JOIN dbo.XPRODUCTSECTION
ON dbo.Product.ID = dbo.XPRODUCTSECTION.ProductID
INNER JOIN dbo.Section
ON dbo.Section.ID = dbo.XPRODUCTSECTION.SectionID
WHERE dbo.Section.ID = 5 and dbo.Product.ID in (12, 13, 22, 27, 32, 65, 81, 121, 124, 125, 131, 132, 136, 149, 225, 334, 379, 430, 431, 433, 441, 442, 443, 444, 448)
Order By Product.Amount
#gifts.RecordCount# items total :: Showing items #StartRow_zerafina#–#EndRow_zerafina# Previous | Next
|
|
|