Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problems with my program
Message
 
À
02/12/2002 14:37:31
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
00728641
Message ID:
00728807
Vues:
26
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform