Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Selecting fields based on another field in the same record
Message
De
10/09/2004 13:41:21
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, États-Unis
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Selecting fields based on another field in the same record
Divers
Thread ID:
00941126
Message ID:
00941126
Vues:
80
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
Very fitting: http://xkcd.com/386/
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform