I'm not sure if my syntax for this is correct for Firebird, but I'm
certainly not getting the results I expect to get...

SELECT
TEMP_EMAIL3.EMAIL_ADDRESS
FROM TEMP_EMAIL3
INNER JOIN RECIPIENT ON (TEMP_EMAIL3.EMAIL_ADDRESS =
RECIPIENT.EMAIL_ADDRESS)
WHERE
(
(TEMP_EMAIL3.EMAIL_ADDRESS NOT IN
(
SELECT RECIPIENT.EMAIL_ADDRESS
FROM RECIPIENT WHERE
RECIPIENT.FK_CLIENT_ID = :A_CLIENT_ID
)
)
)


Myles

===============================
Myles Wakeham
Director of Engineering
Tech Solutions USA, Inc.
Scottsdale, Arizona USA
www.techsolusa.com
Phone +1-480-451-7440