Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel Help
Message
 
À
05/12/2003 14:24:12
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Divers
Thread ID:
00856395
Message ID:
00856407
Vues:
14
Is it what you mean:
import from (excel_file) XLS
SELECT A.A, b.a FROM (alias()) a, (alias()) b WHERE a.b=b.c
>Hello all
>
>I have the following table in excel
>
>Full Name HisSuper SuperId
>DAVIES, ROBERT K 1 1
>WILLIAMSON, BRUCE E 1 2
>WOLFE, THOMAS B 1 3
>CARLSON, JERRY 2 4
>KEATING, JOHN P 9 5
>SWARTZ, KURT 3 6
>DENISON, LESTER 5 7
>RICHARDS, KARYN B 1 8
>JENSEN, JAMES K 1 9
>FRANK, PETER J 8 10
>DUNSTAN, FRANK 1
>KASHDAN, LINDA R 1
>REILLY, SUSAN 1
>SHEEHAN, FRANCIS E 1
>ANDRITZ, GERALD J 2
>CRAWFORD, SLOANE N 2
>GORKA, DEBRA A 2
>KRAMARCHYK, MARY C 2
>LEE, DAVID 2
>SCHMID, DOUGLAS A 2
>BERNHARD, DOUGLAS 3
>FRASER, CAROLE A 3
>PERHAM, DENNIS R 3
>VANDREI, CHARLES E 3
>DENHAM, JASON 4
>DIAMOND, STEPHANIE J 6
>VERSCHOOR, KARIN 6
>EDDY, DARRYL G 7
>HUGHES, DONALD R 7
>MORRELL, ROBERT A 7
>REYNOLDS, TIMOTHY A 9
>MESSENGER, ROBERT 10
>
>
>How can i get the values of Full name based on "hissuper" for example
>supervisor for row 2 is 1=Davis Robert K,like wise i want for all the values.
>
>Thank you for any help
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform