Select from table 1 where NOT IN Table 2

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Select from table 1 where NOT IN Table 2

Message

From

11/11/1999 16:58:45

Bob Archer
Tampa, Florida, United States

11/11/1999 16:32:56

Jim Finger
Digitus Associates, Llc
Ridgefield, Connecticut, United States

General information

Forum:

Visual FoxPro

Category:

Databases,Tables, Views, Indexing and SQL syntax

Title:

Re: Select from table 1 where NOT IN Table 2

Miscellaneous

Thread ID:

00290304

Message ID:

00290320

Views:

>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

Map

View

Click here to load this message in the networking platform