Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Foxpro can't query on two tables more than 7m
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01219859
Message ID:
01220375
Views:
25
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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform