Hi, Yes, this is not supported. Couldn't you use a join?
Regards, Thomas On Mon, Nov 19, 2012 at 10:38 AM, bluerainfj <[email protected]> wrote: > execute SQL: SELECT * FROM ZZJG1_3 WHERE (DXMC,F_OBJNAME) IN (SELECT > DXMC,F_OBJNAME FROM ZZJG1) > > > ERROR Message: > > Subquery is not a single column query; SQL statement: > SELECT * FROM ZZJG1_3 WHERE (DXMC,F_OBJNAME) IN (SELECT DXMC,F_OBJNAME > FROM ZZJG1_3) [90052-168] 90052/90052 (Help) > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To view this discussion on the web visit > https://groups.google.com/d/msg/h2-database/-/pRstnnRFM4kJ. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/h2-database?hl=en. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
