>Hi all,
>want to findout uncommon records from two table base on a field.please help
>me
>thanks.

Do you mean something like this :

SELECT 'A' as 'NotIn',* from tableB ;
  WHERE  NOT exist ;
  (select * from tableA WHERE tableA.CommonField=tableB.CommonField) ;
union ;	
SELECT 'B' as 'NotIn',* from tableA ;
  WHERE  NOT exist ;
  (select * from tableB WHERE tableA.CommonField=tableB.CommonField)

Cetin