Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Strange SQL result
Message
 
 
À
04/01/2005 18:25:33
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00974162
Message ID:
00974255
Vues:
29
>Now since VFP uses a different alias during the SQL select, we have a way to tell it the alias we want. Since I don't have your data and don't have the time to reconstruct the case - how about trying this:
>
SELECT claims.claimno,ln.startdate,claimnt.lname,;
>statute.statgrp_id,ln.link_id  FROM claims;
>left JOIN links ln ON claims.claim_id=ln.parent_id;
>left JOIN claimnt ON ln.child_id=claimnt.claimnt_id;
>left JOIN statute ON ln.statute_id=statute.statute_id;
>where ln.ltype="CLCT" AND claims.claim_id=49142 ;
>AND NOT DELETED("ln")
>
>
>Who knows, may work, and may be a way to use VFP functions which use aliases.

I know that it's not going to work because you cannot control what alias a table will be open by VFP in SQL SELECT.
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform