Wednesday, 21 August 2013

SQL: Use of with-clause in "not in"-operator

SQL: Use of with-clause in "not in"-operator

is it possible to realize something like this?
WITH subQ(attr1) as (SELECT attr1 FROM tab1)
SELECT tab2.attr2, FROM tab2
where tab2.attr2 not in subQ
I don't want to write the subselect after the "not in".

No comments:

Post a Comment