Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help with this query
Message
From
16/12/2004 11:12:42
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Help with this query
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows '98
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00969762
Message ID:
00969762
Views:
46
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?
Next
Reply
Map
View

Click here to load this message in the networking platform