[support] views 'WHERE NOT EXISTS' Query

Hi,

I am building a drupal site with views and CCK that is used to manage a member list and payments of these members. So i have a content type "member" and a content type "payment". The payment content type has a node reference field to the "member" content type.

Now i want to build a view that lists members that have not payed in this year.

Basically, this SQL query explains (and gives me the right results) what i am trying to query:

SELECT * FROM content_type_member WHERE NOT EXISTS ( SELECT * FROM content_type_payment WHERE content_type_member.nid=content_type_payment.field_member_nid and content_type_payment.field_jaar_value=2010 )

The problem is that i cannot figure out how to translate this query into a view.

Is this possible to build such a view ? Can anybody help me with this ?

Thanks in advance, Jos