Linking two different content types with Views I was wondering if one can link up the data with views in this way:

I have two content types (current_state &amp; desired_state), both have 3 fields (location, item, quantity)

How can I join the data, so that it displays in a table like:

location | item | desired_quantity | current_quantity


I separated those content types because people with other permissions are allowed to edit them.
Suppose we have 2 content types A and B and want to display the content of content type B which have a field reference ie both A and B both have a common field.
then:


We simply add B to the Filter Criteria of the view.
Add an nid of A using Contextual Filter in the advance Options.
Add a relationship of B in reverse order in the relationship field in advance options.