[Typo3-dev] Nested Queries in MySQL wrapper class

[Joel Faucett]

Karsten Dambekalns wrote:

>Indeed, if you really tried to use nested queries, this won't work
>with MySQL. Plus it won't be supported by the SQL parser of the DB
>wrapper stuff in TYPO3.
>  
>
I really did try to use them.  I've used Oracle for the past 2 years at 
school, so nested queries are like second nature.

>Have you tried the SQL statement on the command line, i.e. have you
>verified it works outside of TYPO3?
>
>To make it work, you could perform the first select, implode the
>results and then use the list of ids directly in your query.
>  
>
That is how I ended up implementing it, thanks for all the help, list.

Joel