Re: [h2] Re: Error while executing query "Subquery is not a single column query; SQL statement:"

[Noel Grandin]

we don't support multiple-column-IN queries, you'll need to rewrite it as a
JOIN​

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

[h2] Re: Error while executing query "Subquery is not a single column query; SQL statement:"

[Steve McLeod]

Have you tried concatenating the two columns into one column?

I don't know if that would work, just an idea.

PS: I think you'd have more success finding a solution if you post this on 
stackoverflow.com


On Wednesday, 5 October 2016 09:14:06 UTC+2, Ramesh Elkaturi wrote:
>
> Hi all,
>
>
> I tried to execute below query then it is returning error saying 
> that "Subquery is not a single column query; SQL statement: 
> ".
>  
> but it is working on other databases like DB2, Datacom etc...I have googled 
> the issue some of the folks are saying this feature not supported by H2 and 
> Derby. Can any body suggest me the solution or work around for this.
>
>
>   * My Query: *
>
>SELECT * FROM REPORTINFO  WHERE (REPORTINFOID , VERSION ) IN 
> (SELECT REPORTINFOID , MAX(VERSION ) AS VERSION  FROM REPORTINFO  WHERE 
> DELETED =FALSE GROUP BY REPORTINFOID )
>

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.