Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL on Two Tables where All Fields Match
Message
From
05/07/2001 14:39:26
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00526958
Message ID:
00527118
Views:
41
>Something like:
>
>SELECT tableA
>SCAN
>	SCATTER NAME oTableArec
>	SELECT tableB
>	SCAN
>		SCATTER NAME oTableBrec
>		lMatch = COMPOBJ(oTableArec, oTableBrec)
>		IF lMatch
>			* do something
>		ENDIF
>	ENDSCAN
>ENDSCAN
>
Nick,

A few modifications to fit my need, but that logic worked great! Thanks!

Renoir
Previous
Reply
Map
View

Click here to load this message in the networking platform