_____________________________________________________________________________________________
***janela 1***
CNES
select Est_CH.unidade_id,EQ_CH.*,lfces043.prof_id from LFCES004 B,LFCES037 EQ_CH, from LFCES004 EST_CH, LFCES038 PROF WHERE ( (B.CD_MOTIVO_DESAB <> ") OR (B.STATUSMOV='1') ) AND A.CNES_CHDIFER = B.CNES AND PROF.PROF_ID AND PROF.COD_MUN =A.COD_MUN AND PROF.COD_AREA =A.COD_AREA AND PROF.SEQ_EQUIPE =A.SEQ_EQUIPE AND PROF.FL_EQUIPEMINIMA ='1' AND EQ_CH.COD_MUN =A.COD_MUN AND EQ_CH.COD_AREA =A.COD_AREA ANDEQ_CH.SEQ_EQUIPE = A.SEQ_EQUIPE AND EQ_CH.UNIDADE_ID =EST_CH.UNIDADE_ID AND ((EST_CH.STATUSMOV IN ('2' , '3')) OR (EQ_CH.STATUSMOV IN('2','3')))
____________________________________________________________________________________________
***janela 2***
scnes
qryConsulta1: Cannot perform this operation on a closed dataset.
_____________________________________________________________________________________________
Se alguém sabe o que está acontecendo e puder me responder ficarei muito Grato!!!!
