Your query does not really make sense. What are you trying to achieve?

Mark

Myles Wakeham wrote:

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

--
Mark Rotteveel <Avalanche1979@...>