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:
00728800
Vues:
17
Are you joining 4 tables with no Join? Wouldn't that cause a cartesian join (all records from the 1st table joining all the records from the 2nd, the 2nd with all the 3rd, the 3rd with all the 4th? If you didn't have much data to begin with, there would not be much time to query it... but later, if you tried it out on larger tables, it would overflow the harddrive (possibly).

Tommy

>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.
Tommy Tillman A+ NetWork+ MCP
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform