Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
3 table join
Message
From
17/02/2011 03:02:27
 
 
To
16/02/2011 12:45:19
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 8 SP1
Miscellaneous
Thread ID:
01500313
Message ID:
01500475
Views:
39
In a full join having the fastest way to calc each line may be important.
I'm pretty sure that
select nvl(T.PK, P.PK) as PK, nvl(T.FK, P.FK) AS FK, P.pNo, P.pDesc, T.tno, T.tDesc;
from Parts P full join Tools T on P.PK = T.PK and P.FK = T.FK into cursor csrToolsParts
is easier on resources and for my taste on the eyes as well ;-)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform