My concern with doing it this way is performance. If Table 2 is a
fairly large table then two select statements are being processed
instead of 1. This makes the Oracle solution appear better, was just
hoping firebird had the same type of functionality. I will proceed with
this solution unless some other solution is provided.



________________________________

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



Hello Jeremy,

WJ> Select min (col1)
WJ> From table1
WJ> Where (col2, col3) in
WJ> (select col4, col5 from table2 where col6 = variable);

I guess in FB it should be

Select min (col1)
From table1
Where col2 in
(select col4 from table2 where col6 = variable) and
col3 in
(select col5 from table2 where col6 = variable);



--
HTH
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]