Sous requête active record

[eluser]Bloupies[/eluser]
Hello,

I want to do something like that in CI :

Code:

update table1
set columnName = "nice"
where columnName_id not in ( select columnName_id from table2);

Is this possible to do it under another ?

[eluser]InsiteFX[/eluser]
db query