Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What's wrong with SQL in VFP8.0?
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00800321
Message ID:
00800398
Views:
28
That doesn't solve the problem.

Imagine two tables...

Table A has two records, record 1 has ID = 123 and record 2 has ID = 124. Then table B, record 1 has value 124.

If I do

Select *;
From A Full Join B;
On A.ID = B.ID;
Where A.ID <> B.ID

In 6.0 it will return ID=123 but in 7.0 OR 8.0 it will not return any records.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform