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:
01220375
Vues:
18
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 seems to be a bug in VFP 5, this works fine on my homecomputer with vfp 9 but at work it fails. Too bad for me . Could this be achieved w/o a left outer join (because left outer join has been introduced in VFP 5). Thanks beforehand. I have tried Edward's suggestion, but this is not workable.
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform