General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Accesing to a field in a table
Hello, i've created a table with a query, this is my query:
SELECT distinct Llamadas.numero, Llamadas.ingeniero, Ingeniero.codigo,;
Ingeniero.nombre AS ingeniero, Llamadas.fllamada, Llamadas.fcierre,;
(val(sys(11,Llamadas.fcierre))-val(sys(11,Llamadas.fllamada))) AS Dias;
FROM helpdesk!llamadas, helpdesk!ingeniero, helpdesk!festivos;
WHERE Sys(11,Llamadas.fllamada) >= sys(11,m.ini) and;
Sys(11,Llamadas.fllamada) <= Sys(11,m.fin) and ;
Llamadas.ingeniero = Ingeniero.codigo;
AND (EMPTY(Llamadas.fllamada) <> .T.;
AND EMPTY(Llamadas.fcierre) <> .T.);
into table unotab.dbf
I need to deal with the alias field Dias, i been trying with the unotab.dias, but its hopeless, am i doing something wrong?
Please help.
Thanks.
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