SELECT Storage.*, Stock.Количество as Склад FROM Storage left join Stock on Stock.КодНоменклатуры=Storage.КодНоменклатуры where Хранилище=[]