Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Problem
Message
From
13/07/1999 14:27:06
Todd Cottengim
Alpine Land Information Services
Redding, California, United States
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00240873
Message ID:
00240893
Views:
30
Thanks Tom.

The folowing SQL replaces Sql_3
SELECT fld_a + fld_b FROM tbl_1 WHERE fld_a + fld_b IN (SELECT fld_a + fld_b FROM tbl_2 HAVING DELETED()) UNION SELECT fld_a + fld_b FROM tbl_1 WHERE DELETED().

BTW - BUG WARNING
We found that Sql_3 worked in VFP 6 as written the first time, so we are assuming that VFP 3 has a bug.

Thanks to all who chipped in.

Todd Cottengim
Alpine Land Information Services
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform