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
******************************************************************