General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only