Subject | problem with multicolumn subselect |
---|---|
Author | Wilson, Jeremy |
Post date | 2005-07-26T17:33:10Z |
In an oracle view I the following sql statement, I can't seem to get it
coded in firebird correctly, I get a token unknown on the comma in the
where clause. Any help would be appreciated:
Select min (col1)
From table1
Where (col2, col3) in
(select col4, col5 from table2 where col6 = variable);
coded in firebird correctly, I get a token unknown on the comma in the
where clause. Any help would be appreciated:
Select min (col1)
From table1
Where (col2, col3) in
(select col4, col5 from table2 where col6 = variable);