Select where not exists - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Select where not exists

Message

From

16/12/2004 16:08:38

Alan Shepard
Not an astronaut
Ashton-U-Lyne, United Kingdom

To

16/12/2004 16:00:24

Geoff Scott
Christchurch, New Zealand

General information

Forum:

Visual FoxPro

Category:

Databases,Tables, Views, Indexing and SQL syntax

Title:

Re: Select where not exists

Miscellaneous

Thread ID:

00969838

Message ID:

00969840

Views:

8

This should do it

SELECT * FROM table1 WHERE NOT IN (SELECT FROM table2) INTO CURSOR query

Click here to load this message in the networking platform