'Not in' in Common SQL

Anyone knows how to express following SQL in Common SQL extension?

select id from foo where id not in (select id from bar);

I tried alomost every possibilies starting from:

[select [id] :from [foo] :where [NOT-IN [id] [select [id] :from [bar]]]]

- Jong-won