Синтаксис Join

[андрей]

while select Category, count(ItemId) from _ShopInventItems
group by Category
join Field1, Field2 from _ShopKinds
group by Field1, Field2
where _ShopInventItems.Category == _ShopKinds.Category