Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Foxpro can't query on two tables more than 7m
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01219859
Message ID:
01223579
Vues:
19
>You can try correlatade subquery but it most likely will be much slower
>
>Select * ;
>	from PrevYear ;
>	WHERE NOT EXISTS ( SELECT * FROM thisyear ;
>				WHERE PrevYear.mijbrpls = thisyear.mijbrpls ;
>					and PrevYear.vlgnr_mut = thisyear.vlgnr_mut )
>
>

This is indeed much much slower. I have found a solution with Edward's help. As always, thanks for your help.
Zakaria al Azhar
My blog on Actuaris.net
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform