>hello, i have this query:
>

>SELECT Clo_llamadas.id_repser AS Servicio, Cl_ingeniero.nombre_ing AS Responsable, Clo_Llamadas.serie AS serial,;
>  Clo_cliente.nombre_cli, ciudad.nombre AS Ciudad, Clo_Llamadas.fgeneracion AS fecha,Clo_Llamadas.fech_ini as finicio, Clo_Llamadas.fech_fin AS ffinal, left(Clo_llamadas.descripcion, 250) AS detalle;
> FROM  helpdesk!clo_llamadas ;
>    LEFT OUTER JOIN helpdesk!cl_ingeniero ON  Clo_llamadas.idingeniero = Cl_ingeniero.id_ing;
>    LEFT OUTER JOIN helpdesk!clo_cliente ON  Clo_llamadas.idcliente = Clo_cliente.id_cliente;
>    LEFT OUTER JOIN helpdesk!ciudad ON  Clo_cliente.id_ciudad = ciudad.codigo;
> WHERE Clo_llamadas.estado="PENDIENTE" OR EMPTY(Clo_llamadas.estado);
> ORDER BY Clo_cliente.nombre_cli;
> INTO CURSOR Qpr_pendien
> REPORT FORM rptcolservice\rpt_pendientes.frx NOCONSOLE PREVIEW
>

>
>the results...
>servicio responsable ..... Estado
>75 Peter Wail PENDIENTE
>75 Peter Wail PENDIENTE
>75 Peter Wail COMPLETA
>76 Jenny Silver PENDIENTE
>
>What i need to do now is that in the case of the service 75 doesn't appears in the query because is "COMPLETA" (COMPLETED)
>How do i do this?

...
WHERE INLIST(Clo_llamadas.estado,"PENDIENTE","");
AND NOT EXISTS(SELECT*FROM elpdesk!clo_llamadas X  WHERE Clo_llamadas.estado="COMPLETA" ;
AND X.PRIMARYKEY=clo_llamadas.PRIMARYKEY)
...