, 20 2018 . 12:46
+
ms access,
, .
:
-"" 1
-"" 2
- 2
-1 1
-2 1
-
-
:
- .
access . :
SELECT (2.[]) AS , COUNT(2.[]) AS , SUM(1.[2]) AS INTO
FROM 1, 2
WHERE [1.1] LIKE 2. + " " & "*"
or [1.1] LIKE "*" & " " + 2. + " " & "*"
or [1.1] LIKE "*" & " " + 2.
GROUP BY [2.]
ORDER BY SUM([1.2]) DESC;
, :
, ,
access, , // .
Visual Studio, WindowsForm, C#
1: Access
2: WinForm
P.S. -
http://www.sql.ru/forum/1285844/vopros-o-access-sql-i-programke
