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