Does the RIGHT & LEFT OUTER JOINs work in VFP7.0? - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Does the RIGHT & LEFT OUTER JOINs work in VFP7.0?

Message

From

21/01/2002 14:33:57

Sergey Berezniker
New York, United States

To

21/01/2002 14:30:27

Mike Mohr
Mckee Foods Corp
Collegedale, Tennessee, United States

General information

Forum:

Visual FoxPro

Category:

Databases,Tables, Views, Indexing and SQL syntax

Title:

Re: Does the RIGHT & LEFT OUTER JOINs work in VFP7.0?

Miscellaneous

Thread ID:

00607928

Message ID:

00607930

Views:

21

This message has been marked as the solution to the initial question of the thread.

>I have tried several different methods to get the RIGHT OUTER JOIN to work, but it always returns an INNER JOIN. Why?

Maybe your WHERE clause filters out records added by outer join?

--sb--

Click here to load this message in the networking platform