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:
00728800
Views:
16
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
Previous
Reply
Map
View

Click here to load this message in the networking platform