如何选择在另一个表中没有匹配项的行?

I'm doing some maintenance work on a database application and I've discovered that, joy of joys, even though values from one table are being used in the style of foreign keys, there's no foreign key constraints on the tables.I'm doing some maintenance work on a database a