 |
|
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 = 1 and dbo.Category.ID in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 39)
Order By CategoryID DESC
#athome.RecordCount# items total :: Showing items #StartRow_zerafina#–#EndRow_zerafina# Previous | Next
|
|
|
|
