I have a "Company" node type and a "Content" node type.
In my User profiles I have added a nodereference to the appropriate Company node, and in the Content nodes, I have also added a nodereference to the Company owning the content.
What I am trying to do is to construct a view that will present the logged-in user a list of all Content nodes owned by (i.e. with references to) the user's company.
Pseudo-sql would be something like this:
SELECT n.title FROM node n,user u WHERE n.company_reference = u.company_reference AND logged_in_user.uid = u.uid
There ought to be a way to do this via Views, I just have been unable to figure out how, so any suggestions or pointers will be greatly appreciated