Буду очень благодарен, если подскажете где ошибка
Select Katmc.Name, tt1.kol as OS, tt2.kol as YG, tt3.kol as DM
from Katmc
left join (Select t1.*, p1.* from Sklost t1 left join Katpodr p1
on Katmc.Nrec=t1.cmc and t1.cpodr=p1.Nrec
and 'Основной склад'=p1.Name) tt1
left join (select t1.*, p1.* from Sklost t1 left join Katpodr p1
on Katmc.Nrec=t1.cmc and t1.cpodr=p1.Nrec
and 'Склад "Детский мир'=p1.Name) tt2
left join (select t1.*, p1.* from Sklost t1 left join Katpodr p1
on Katmc.Nrec=t1.cmc and t1.cpodr=p1.Nrec
and 'ЮГЗ-Рынок'=p1.Name) tt3
left join Tekmc on Katmc.Nrec=Tekmc.cmc
order by Katmc.name