Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Selecting fields based on another field in the same reco
Message
De
10/09/2004 13:45:07
 
 
À
10/09/2004 13:41:21
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00941126
Message ID:
00941127
Vues:
12

Hello,
I have a table like following:

CODE|IDUSE |
---------------
A |FAXA |
V |FAXB |
A |FAXC |
---------------

What I want is to run a select statement on this table that finds when the IDUSE matches FAX(which I will be supplying through code)+CODE (so the only one that would correctly show is FAXA). Sorry if I didn't explain this very well... but any help would be greatly appreciated. Thanks!!

MAC
SELECT ... EVAL(IDUSE) AS FAX ...
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform