Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Multiple joins on Select help
Message
De
05/06/2003 10:02:55
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Multiple joins on Select help
Divers
Thread ID:
00796679
Message ID:
00796679
Vues:
32
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.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform