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:32:56

All

General information

Forum:

Visual FoxPro

Category:

Databases,Tables, Views, Indexing and SQL syntax

Title:

Select from table 1 where NOT IN Table 2

Miscellaneous

Thread ID:

00290304

Message ID:

00290304

Views:

Does Fox SQL Syntax allow for following?:

SELECT table1.orderid FROM table1 WHERE table1.orderid NOT IN table2.orderid

Thanks,

Jim Finger