One way to do it would be the following: Given: field xx is the common field among table A and table B SELECT * FROM A WHERE xx NOT IN(SELECT xx FROM B) HTH, Garritt ****************************************************************** Garritt Grandberg, Programmer/Analyst Visionary Systems, Ltd Des Moines, IA E-Mail: Garritt@visionary.com http://www.visionary.com ******************************************************************