Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Join on inequality
Message
From
11/10/2001 12:10:19
 
 
To
11/10/2001 11:06:16
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00566970
Message ID:
00567059
Views:
14
Hilmar,


Would the 'where ... in (select ...) ' not work ?

Something like (not tested)
select tmpReport.*,;
	L1.* ;
	from tmpReport, LiquidationPrice L1 ;
	into cursor tmp ;
	where	( (bintoc(tmpReport.artparent) + dtos(tmpReport.PlanMonday)) ;
				in (	select max( bintoc(liquidationprice.article) + dtos(liquidationprice.planweek) ) ;
						from LiquidationPrice L2 ;
						where ( bintoc(L2.article) == bintoc(tmpReport.artparent) ) ;
					) ;
			)
Gregory
Previous
Reply
Map
View

Click here to load this message in the networking platform