
SQL
- 9 ответов
- 0 вопросов
3
Вклад в тег
"C:\Program Files\1cv8\common\1cestart.exe" ENTERPRISE /S"srv-1c-01\Database01" /N"Username" /P"UsernamePassword" /Execute "C:\Sbis1C\RobotSBIS_UF.epf"
SELECT Firms.Name, Count(*)
FROM phones
LEFT JOIN Firms ON Firms.id = phones.Firma_id
GROUP BY Firms.Name