Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
NOT Equal to
Message
From
12/07/2003 03:21:04
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
NOT Equal to
Miscellaneous
Thread ID:
00809537
Message ID:
00809537
Views:
52
two tables have same structure. One table has more records that not in other table. I want to get those records. I wrote this SQL query but got Cartision product.

SELECT ffs.ccod, ffs.cnam, smc.ccod, smc.cnam from ffs, smc WHERE ffs.ccod<>smc.ccod

TIA

Nafees
Next
Reply
Map
View

Click here to load this message in the networking platform