SELECT CategoryName FROM StoreCategories
WHERE CategoryID = #CategoryID#
SELECT StoreItems.*, StoreManufacturers.Name
FROM StoreItems, StoreManufacturers
WHERE StoreItems.ManufacturerID = StoreManufacturers.ManufacturerID
AND CategoryID = #CategoryID#
Eanet jepi1 #GetCurrentCategory.CategoryName#