I am slowly but surely becoming a firebird fan for any java application.



________________________________

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Pavel Menshchikov
Sent: Tuesday, July 26, 2005 3:44 PM
To: Wilson, Jeremy
Subject: Re: RE: [firebird-support] problem with multicolumn subselect



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



++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++





________________________________

YAHOO! GROUPS LINKS



* Visit your group "firebird-support
<http://groups.yahoo.com/group/firebird-support> " on the web.

* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
<mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe

>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .



________________________________



[Non-text portions of this message have been removed]