 |
|
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 (30, 31, 37, 65, 81, 121, 126, 173, 179, 180, 229, 230, 232, 342, 413, 414, 416, 417, 421, 424, 431, 430, 446, 447)
Order By Product.Amount
#gifts.RecordCount# items total :: Showing items #StartRow_zerafina#–#EndRow_zerafina# Previous | Next
|
|
|
