Select from table 1 where NOT IN Table 2

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Select from table 1 where NOT IN Table 2

Message

11/11/1999 16:58:45

Bob Archer
Tampa, Floride, États-Unis

11/11/1999 16:32:56

Jim Finger
Digitus Associates, Llc
Ridgefield, Connecticut, États-Unis

Information générale

Forum:

Visual FoxPro

Catégorie:

Base de données, Tables, Vues, Index et syntaxe SQL

Titre:

Re: Select from table 1 where NOT IN Table 2

Divers

Thread ID:

00290304

Message ID:

00290320

Vues:

>Does Fox SQL Syntax allow for following?:
>
>SELECT table1.orderid FROM table1 WHERE table1.orderid NOT IN table2.orderid
>
>Thanks,

SELECT table1.orderid FROM table1 WHERE table1.orderid NOT IN (select table2.orderid from table2)

or, in VFP 6.0 this is I think an OUTTER JOIN would do this too.

BOb

Répondre

Fil

Voir

Click here to load this message in the networking platform