Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table comparison process assistance...
Message
 
 
To
11/11/2002 15:04:04
N. Lea
Nic Cross Enterprises
Valencia, California, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00721202
Message ID:
00721225
Views:
9
SELECT *, "Y" as match FROM tableA ;
  WHERE first_name + last_name NOT IN ( ;
    SELECT first_name + last_name FROM tableB) ;
UNION ALL ;
SELECT *, "N" as match FROM tableA ;
  WHERE first_name + last_name IN ( ;
    SELECT first_name + last_name FROM tableB) ;
  INTO CURSOR crsA READWRITE
>Is there anyway to also bring over the names that matched too?
>
< snip >
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform