Nested selects with Active Record

[eluser]dangermark[/eluser]
Hi all,

Is it possible to do nested select queries in Active Record?

Something that would generate:

Code:

SELECT * FROM table1 WHERE id IN (SELECT id FROM table2)

If it's not possible, an idea (or link) on the best way to accomplish this in CI would be great.

Thanks for your time.