On 09.03.12 13:42, Thomas Fox (Created) (JIRA) wrote: > Allow subselects which do not reference a column > ------------------------------------------------ > > Key: TORQUE-185 > URL: https://issues.apache.org/jira/browse/TORQUE-185 > Project: Torque > Issue Type: New Feature > Reporter: Thomas Fox > > > Currently it is not possible to create the following prepared statement query: > select * from TABLE_1 where (select count(*) from TABLE2 where TABLE2.COLUMN1 > = TABLE1.COLUMN1 AND TABLE2.COLUMN2=?) = 0; > It should be possible to create such queries.
Would that allow queries of the form select stuff from (select otherstuff from table) ? If not, and while we are at it, I'd open a JIRA issue for that. Bye, Thomas. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
