From the course: Learning Data Analytics: 1 Foundations

Unlock this course with a free trial

Join today to access over 25,500 courses taught by industry experts.

Working with joins and validation

Working with joins and validation

From the course: Learning Data Analytics: 1 Foundations

Start my 1-month free trial Buy for my team

Working with joins and validation

“

- [Instructor] When you join data, you were using a field of data that is the same in both tables. And it is the same data type. Sometimes they will be named the same and sometimes they will not. If you will open up bad link in design view, you're going to notice that product ID is related to sales order ID. I've noticed through the years that this is a common mistake when people are learning to link data together. When you run this query if you see either no results or limited results, the very first thing that you'll check is did you join the appropriate fields? I'll go ahead and run this. And I see no results. That's because product ID and sales order ID should not be linked. I'll go ahead and go back to my design view. I'll delete this link. The appropriate link would be product ID to product ID. And then when I run my results, I'll see the answer of where my product is related to my sales orders. Let's talk about another common mistake that produces a cross join. Right click and…

Contents