Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Add new records
Message
From
27/09/2002 14:46:30
 
 
To
27/09/2002 14:33:50
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00705382
Message ID:
00705388
Views:
8
Try:

SELECT *,(telephone number+country code+datetime+duration) AS KeyField FROM TableA WHERE KeyField NOT IN (SELECT DISTINCT (telephone number+country code+ datetime+duration) AS KeyField FROM TableB)

If telephone number, country code, datetime, duration are not character type, use STR and DTOC

mandy
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform