 |
|
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 = 6
#kitchstorage.RecordCount# items total :: Showing items #StartRow_zerafina#–#EndRow_zerafina# Previous | Next
|
|
|
|
