SELECT dbo_filial.name, dbo_Salesmonthform.Lager_id, dbo_lager.ShortName, dbo_format.GroupTovar, dbo_format.Name, dbo_Salesmonthform.kolart, dbo_Salesmonthform.sumart, prirost.` 4 `, dbo_Salesmonthform.month, dbo_lagerWidth.Width
FROM `D:\base\base`.dbo_filial dbo_filial, `D:\base\base`.dbo_format dbo_format, `D:\base\base`.dbo_lager dbo_lager, `D:\base\base`.dbo_lagerWidth dbo_lagerWidth, `D:\base\base`.dbo_Salesmonthform dbo_Salesmonthform, `D:\base\base`.prirost prirost
WHERE dbo_lager.id = dbo_Salesmonthform.Lager_id AND prirost.art = dbo_Salesmonthform.Lager_id AND dbo_format.id = dbo_Salesmonthform.Format_id AND dbo_filial.Id = dbo_Salesmonthform.Fil_id AND dbo_lagerWidth.Lagerid = dbo_Salesmonthform.Lager_id