Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problems with my program
Message
 
To
02/12/2002 14:37:31
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00728641
Message ID:
00728807
Views:
19
>this is my query from alarabierta.qpr:
>
>Select 	llamadas.numero		as 		numero,;
>		llamadas.fllamada	as      fllamada,;
>		llamadas.fatencion  as 		fatencion,;
>		llamadas.usuario	as 		nombre_a,;
>		llamadas.modelo		as		modelo,;
>		llamadas.undhard	as 		undhard,;
>		llamadas.ingeniero 	as 		nombre_b,;
>		llamadas.host		as 		host,;
>		llamadas.detalle 	as		detalle;
>From llamadas,usuarios_cia,modelos,ingeniero ;
>Where  Empty(llamadas.fatencion);
>Group by numero ;
>Order by numero ;
>into cursor servil
>Report form alarabierta previ
>
>
>Thanks for your help.

Edgar;

Based upon the llamadas table you should have
Select 	llamadas.numero		as 		numero,;
		llamadas.fllamada	as      fllamada,;
		llamadas.fatencion  as 		fatencion,;
		llamadas.usuario	as 		nombre_a,;
		llamadas.modelo		as		modelo,;
		llamadas.undhard	as 		undhard,;
		llamadas.ingeniero 	as 		nombre_b,;
		llamadas.host		as 		host,;
		llamadas.detalle 	as		detalle;
From llamadas ;
Where  Empty(llamadas.fatencion) ;
Group by numero ;
Order by numero ;
into cursor servil
Report form alarabierta previ
As Tommy pointed out you have no join condition for the other tables. Do you need to have the other tables joined?

Tom
Previous
Reply
Map
View

Click here to load this message in the networking platform