| |
 60 Кб. |
|
| | Добрый день! Помогите пожалуйста с такой ситуацией -> см. приложение. Такое возможно реализовать??? | |
| |
| |
| |
|
|
| |
INSERT INTO Table2 ( Kod, [Sum], EXP )
SELECT Kod, Summ, 'SK ZB' AS EXP
FROM (SELECT Kod, Sum(Clng([Sum])) AS Summ FROM Table1 GROUP BY Kod);
|
| |
| |
| |
|
|
| |
|
|
| | Еще проще:
INSERT INTO Table2 ( Kod, [Sum], EXP )
SELECT Kod, Sum(Clng(Table1.Sum)) AS [Sum], 'SK ZB' As EXP
FROM Table1
GROUP BY Kod;
|
| |
| |
| |
