help with multi-table query

I hope someone out there can solve the following problem I have two tables table1 table2 lastName firstName lastName tom doug tom john doug john jackson mathew john wilson I need an SQL statement which will 1) fetch all lastnames from table1 WHICH ARE NOT in Table2 and the firstname is doug Such a query, when applied to the above will return a list from table1 which include jackson, wilson. The lastname fields are foreign keys. Any help would be greatly appreciated. Thank you in advance -- -------------------------------------------------------------------------------- Rickey Tom | Internet Style: aruba!rickt@uu2.psi.com Programmer/Analyst Project ZE | UUCP : ...!uunet!uupsi2!aruba!rickt --------------------------------------------------------------------------------