Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Statement
Message
De
11/05/2005 11:29:54
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
SQL Statement
Versions des environnements
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01012914
Message ID:
01012914
Vues:
61
I have two tables as follows:
callreport.dbf
callrepid   actionid1  actionid2 ...  actionid10 ....


actions.dbf
actionid    action
I need an sql statement that will produce a cursor containing only the callrepids from callreport.dbf that have an actionid (1-10) that is in the actions dbf.

Hope this makes sense.

Thanks in advance for your help!
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform