Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Multiple joins on Select help
Message
From
05/06/2003 10:02:55
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Multiple joins on Select help
Miscellaneous
Thread ID:
00796679
Message ID:
00796679
Views:
31
I've been struggling with this syntax for a while now. I must be doing something really wrong.

I have 2 tables
tactualdata & tparams.
tactualdata.fkey is a compound '.' delimited data field
why they did it this way, I dont know?
where tactualdata.fkey corresponds to tparams.ffeature+'.'+tparams.ftoolset+'.'+tparams.fisnum

I want to build a cursor that contains all the tactuadata records and (the tparams records that match on ffeature and on ftoolset.

I am trying
Select *;
	from dbtwiz!tactualdata ;
	left Join dbtwiz!tparams;
	ON(Thisform.zgetfeature(tactualdata.fkey) = Alltrim(tparams.ffeature) And ;
	thisform.zgettoolset(tactualdata.fkey) = Alltrim(tparams.ftoolset)) ;
	into Cursor cExport Readwrite
this matches up the ffeature field correctly but it does not match up the ftoolset correctly.
Next
Reply
Map
View

Click here to load this message in the networking platform