Views, getting nodes type 1 which user have NO node of type 2 published that references the node type 1 I'm using drupal 7.20 with Views 3 module.

I've a content type "Homework" and a content type "Solution". The Solution content type has an entity reference field that references nodes of type "Homework".

Well, I'm trying to set up with Views a new Tab in the user profile menu: "Pending Homeworks" that lists all Homeworks that has no Solution referencing them and published by that user.

Best an example:

"Homework 1" &lt;- "Solution (by user 1)"
             &lt;- "Solution (by user 2)"
             &lt;- "Solution (by user 3)"

"Homework 2" &lt;- "Solution (by user 1)"
             &lt;- "Solution (by user 3)"

"Homework 3" &lt;- "Solution (by user 3)"


In this example, user 2 hasn't published yet his Solution for Homework 2 and Homework 3, so, the View I want, must output: Homework 2 and Homework 3.

Thanks in advance.
This has already been answered here.

A simple view will not do what you want.