Another Example of “Relationship May Be Needed” When You Do, In Fact, Have a Relationship
Let’s pick up the topic from last week and examine another instance where you might encounter the dreaded warning message above.
Let’s start with this simple pivot:
Which is a column from the Years table and a column from the Movies table:
But now I have a new table: Animals, which simply lists, for each year, which Animal is specified by the Chinese Zodiac:
Hollywood Insiders Know That the Animals of the Chinese Zodiac Are
Incredibly Important to Box Office Revenues