Пишу скрипт в поле таблицы базы данных:

_{insert into T_CNT_FRM
select distinct t1.ko '' fs spec, 2 as idc, 3 as gr_st, t1.zn as lft, NULL as rt, NULL as delta
from frm_data_1 t1
left join frm_data_1 t2 on t1.ko=t2.ko and t1.st=t2.st and t1.s1=t2.s1 and t2.gr=3
where t1.st not in('3','5') and t1.gr=3 and t1.s1<>'0' and t1.zn=0 and t2.zn>0 and t2.zc is NULL;} (Раздел 1. Гр.3 стр.2 и 5 > 0)

и при запуске в форме ничего не выводит, а другой скрипт написанный уже нормально работает, чтото понять не могу где ошибся

_{insert into T_CNT_FRM
select distinct t1.ko, t1.s1 as spec, 7 as idc, 9 as gr_st, t1.zn as lft, NULL as rt, NULL as delta
from frm_data_1 t1
left join frm_data_1 t2 on t1.ko=t2.ko and t1.st=t2.st and t1.s1=t2.s1 and t2.gr=9
where t1.st not in('1','2','3','4','5','6','7') and t1.gr=7 and t1.s1<>'0' and t1.zn>0 and t2.zc is NULL;} (Раздел 1. Если гр.7 > 0, то гр.9 не может быть пустой)

тема закрыта.