Hello Jeremy,

WJ> My concern with doing it this way is performance. If Table 2 is a
WJ> fairly large table then two select statements are being processed
WJ> instead of 1. This makes the Oracle solution appear better, was just
WJ> hoping firebird had the same type of functionality. I will proceed with
WJ> this solution unless some other solution is provided.
Yes, I think the better solution would be with EXISTS (refer to
Fabiano's post). I've just pointed you an FB equivalent of your
original Oracle query.


--
Best regards,
Pavel Menshchikov
http://www.ls-software.com