CLEAR ALL
CLOSE all
CREATE TABLE 'ER' (ERRAND_ID I NOT NULL, ERRANDK_ID I NOT NULL, ERRAND_STA I NOT NULL, ;
                     INORDER I NOT NULL, DOC_ID I NOT NULL, PERS_ID_FR I NOT NULL, PERS_ID_TO I NOT NULL, ;
                     PERS_ID_CO I NOT NULL, TIME_CONTR T NOT NULL)
CREATE TABLE RE (RESOL_ID I NOT NULL, ERRAND_ID I NOT NULL, PERS_ID_TO I NOT NULL, ;
                         RESNAME_ID I NOT NULL, REPKIND_ID I NOT NULL, TIME_REPOR T NOT NULL, ;
                         TIME_RESOL T NOT NULL)
SELECT er
_test_errand = 12342
* begin
?SELECT()
SELECT re.* FROM re right OUTER JOIN ;
	(SELECT * FROM er LEFT JOIN ;
	(SELECT er.doc_id, er.errand_sta as cur_etap FROM er WHERE er.errand_id =_test_errand) et ;
		ON er.doc_id = et.doc_id WHERE er.errand_sta < et.cur_etap) ee ;
		ON re.errand_id = ee.errand_id WHERE re.repkind_id in (3,9) OR resol_id is null INTO ARRAY qqq
?SELECT()
SELECT er.doc_id, er.errand_sta as cur_etap FROM er WHERE er.errand_id =_test_errand INTO ARRAY qqq
?SELECT()

1
6
1
1

1
1
1
1