Creating a view that uses fields from two content types I'm reeally struggling with this one. I just can't seem to wrap my head around the way Drupal and Views handles this pretty simple thing...

I have two content types:


Card
Card Content


Card has the following fields:


Title
Body
Display Order
Linked ID


Card Content has the following fields:


Title
Body
Linked ID


In Views, I would like to display:


Card Content - Title
Card Content - Body
Card - Display Order


If I were to write this as an SQL statement, it would be simple:

SELECT a.title, a.body, b.display_order
FROM card_content AS a
  INNER JOIN card AS b
    ON a.linked_id = b.linked_id



How do I achieve this?

Things to note: I originally had the Linked ID as a select box, taken from a set of predefined taxonomy terms. I have since migrated these to entity-references, that pull the data from the taxonomy terms (if that makes sense)?


EDIT: Okay, to clarify things a little...

Linked ID is a select box that's linked to a taxonomy vocabulary. This is purely to limit what a user can input.


As requested, here are screenshots of my Card and Card Content.
Best way is to use entity reference

Below is the youtube link which will provide you step by step explanation of using entity reference module with views.
https://www.youtube.com/watch?v=4Pdii7aFIvc