General information
Title:
Problem with a variable into a select
Hello, i have a problem with a select, im trying to add a variable this is my sentence:
SELECT Ingeniero.nombre, SUM(Llamadas.tiempo_sol),;
AVG(Llamadas.tiempo_sol), SUM(Llamadas.calidad), AVG(Llamadas.calidad);
FROM helpdesk!llamadas INNER JOIN helpdesk!ingeniero ;
ON Llamadas.ingeniero = Ingeniero.codigo;
WHERE Sys(11,Llamadas.fllamada) >= sys(11,m.ini) AND ingeniero.codigo IN (chkvalue);
GROUP BY Ingeniero.nombre;
ORDER BY Ingeniero.nombre;
Into table ingestad.dbf
the variable is chkvalue and it displays an error when you run this query.
How do i solve this? its something wrong in my code?
Please help.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only