Дополнительный фильтр на smmActiviies форме.

[Dima_Dima]

Цитата:

Сообщение от DSPIC

Вы увидете результирующий запрос, по нему и ищите ошибку.

Спасибо за совет!

Первый (рабочий) запрос выглядит так:

SELECT * FROM smmActivities USING INDEX SortIndex WHERE ((Category = 0)) AND ((Sensitivity = 0)) AND ((IsTemplate = 0)) 
        EXISTS JOIN * FROM EmplTable WHERE smmActivities.ResponsibleEmployee = EmplTable.EmplId 
        EXISTS JOIN * FROM EmplTable WHERE smmActivities.ResponsibleEmployee = EmplTable.EmplId 
        EXISTS JOIN * FROM EmplTable WHERE smmActivities.ResponsibleEmployee = EmplTable.EmplId 
        EXISTS JOIN * FROM EmplTable WHERE smmActivities.ResponsibleEmployee = EmplTable.EmplId AND ((DispatchTeamId = N'1 K'))

Второй (если меняю фильтр) оочень интересный:

SELECT * FROM smmActivities USING INDEX SortIndex WHERE ((Category = 0)) AND ((Sensitivity = 0)) AND ((IsTemplate = 0)) 
        EXISTS JOIN * FROM EmplTable WHERE smmActivities.ResponsibleEmployee = EmplTable.EmplId 
        EXISTS JOIN * FROM EmplTable WHERE smmActivities.ResponsibleEmployee = EmplTable.EmplId 
        EXISTS JOIN * FROM EmplTable WHERE smmActivities.ResponsibleEmployee = EmplTable.EmplId 
        EXISTS JOIN * FROM EmplTable WHERE smmActivities.ResponsibleEmployee = EmplTable.EmplId AND ((DispatchTeamId = N'1 K')) 
        EXISTS JOIN * FROM EmplTable WHERE smmActivities.ResponsibleEmployee = EmplTable.EmplId AND ((DispatchTeamId = N'2 M'))

т.е.

EXISTS JOIN * FROM EmplTable WHERE smmActivities.ResponsibleEmployee = EmplTable.EmplId AND ((DispatchTeamId = N'1 K'))

живет еще при втором запросе!!!

Есть ли способ его скинуть???