Sql server not in clause not working
===

Why this does not give any records in sql server 2008?

    ;with pricedCategories as
    (
    	select * from Product.Category where CategoryID not in
    	(select Parent_CategoryID from Product.Category)
    )
    select * from pricedCategories

