Content Type A -Nid A -Field A
Content Type B -Nid B -Reference Nid A
How can I find in a view all As that have no reference in B ?
in sql this is
select A.field FROM TABLE A LEFT JOIN TABLE B ON A.KEY = B.KEY WHERE B.key IS NULL
I have tried Views reference filter, but it is very slow and consume a lot of memory (the trick with this modules is not a join but a SELECT... NOT IN (...).
Which is very inefficient, because, i have 16.000 As and 14.000 Bs.
Is there any efficient solutions with views?