 |
|
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 (399, 400, 401, 402, 403, 404, 405, 406, 60, 250, 143)
Order By VendorID desc
#gifts.RecordCount# items total :: Showing items #StartRow_zerafina#–#EndRow_zerafina# Previous | Next
|
|
|
