Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Nested SQL
Message
De
17/01/2006 11:37:29
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
17/01/2006 11:11:27
Jay Johengen
Altamahaw-Ossipee, Caroline du Nord, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
01087559
Message ID:
01087577
Vues:
14
>I know the nested part of the following SQL is incorrect, but what is the right way?
>
>
>
>SELECT DISTINCT * FROM AllStuff WHERE AllStuff.UserID ! IN (SELECT ExcludeStuff.UserID FROM ExcludeStuff) INTO CURSOR NewStuff
>
SELECT * FROM AllStuff WHERE UserID not IN ;
 (SELECT UserID FROM ExcludeStuff) ;
 INTO CURSOR NewStuff
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform