Hi

>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

Easiest way is to use a sub-query like this:

SELECT ffs.ccod, ffs.cnam, smc.ccod, smc.cnam 
  FROM ffs
 WHERE ffs.ccod NOT IN (SELECT ccod FROM smc)