Форумы HiProg.com - MS ACCESS, VBA, VB

 

Ответить на сообщение

Вернуться к теме

Вы отвечаете на сообщение:

ник: Explorer
SELECT A.Enumerate, B.Enumerate, C.Enumerate, D.Enumerate, E.Enumerate, [A].[Enumerate]+[B].[Enumerate]+[C].[Enumerate]+[D].[Enumerate]+[E].[Enumerate] AS amt
FROM (SELECT 0 AS Enumerate FROM MSysObjects
UNION SELECT 1 FROM MSysObjects
UNION SELECT 2 FROM MSysObjects
UNION SELECT 3 FROM MSysObjects
UNION SELECT 4 FROM MSysObjects
UNION SELECT 5 FROM MSysObjects
UNION SELECT 6 FROM MSysObjects
UNION SELECT 7 FROM MSysObjects
UNION SELECT 8 FROM MSysObjects
UNION SELECT 9 FROM MSysObjects) AS A,
(SELECT 0 AS Enumerate FROM MSysObjects
UNION SELECT 1 FROM MSysObjects
UNION SELECT 2 FROM MSysObjects
UNION SELECT 3 FROM MSysObjects
UNION SELECT 4 FROM MSysObjects
UNION SELECT 5 FROM MSysObjects
UNION SELECT 6 FROM MSysObjects
UNION SELECT 7 FROM MSysObjects
UNION SELECT 8 FROM MSysObjects
UNION SELECT 9 FROM MSysObjects) AS B,
(SELECT 0 AS Enumerate FROM MSysObjects
UNION SELECT 1 FROM MSysObjects
UNION SELECT 2 FROM MSysObjects
UNION SELECT 3 FROM MSysObjects
UNION SELECT 4 FROM MSysObjects
UNION SELECT 5 FROM MSysObjects
UNION SELECT 6 FROM MSysObjects
UNION SELECT 7 FROM MSysObjects
UNION SELECT 8 FROM MSysObjects
UNION SELECT 9 FROM MSysObjects) AS C,
(SELECT 0 AS Enumerate FROM MSysObjects
UNION SELECT 1 FROM MSysObjects
UNION SELECT 2 FROM MSysObjects
UNION SELECT 3 FROM MSysObjects
UNION SELECT 4 FROM MSysObjects
UNION SELECT 5 FROM MSysObjects
UNION SELECT 6 FROM MSysObjects
UNION SELECT 7 FROM MSysObjects
UNION SELECT 8 FROM MSysObjects
UNION SELECT 9 FROM MSysObjects) AS D,
(SELECT 0 AS Enumerate FROM MSysObjects
UNION SELECT 1 FROM MSysObjects
UNION SELECT 2 FROM MSysObjects
UNION SELECT 3 FROM MSysObjects
UNION SELECT 4 FROM MSysObjects
UNION SELECT 5 FROM MSysObjects
UNION SELECT 6 FROM MSysObjects
UNION SELECT 7 FROM MSysObjects
UNION SELECT 8 FROM MSysObjects
UNION SELECT 9 FROM MSysObjects) AS E
WHERE ([A].[Enumerate]+[B].[Enumerate]+[C].[Enumerate]+[D].[Enumerate]+[E].[Enumerate])=5;


Ваше имя:

Пароль:

Цитировать: [quote][/quote] Код: [code][/code]
Жирный: [b][/b] Наклонный: [i][/i]
URL: [url][/url] 

Сообщение:

 Размер файла не более 50 Кбт. Большие файлы можно размещать на www.slil.ru

Прикрепить:

 

Для вставки смайлов в текст щелкните по значку.