Desktop productivity for business analysts and programmers

What is your InnerJoin?

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 104
Accepted Solution

What is your InnerJoin?

I have two tables that I want to join but the results are not I what I wanted.

Capture.PNG

As you can see guest 350106 shows up three times with the same data. I think it is because of the join I did.  I used InnerJoin between GuestNumber from both tables. CharZip is from another table.

Table 1Table 2

GuestNumber

GuestNumber
PlayerDayDateCharZip
Sales

Does anyone know what I did wrong?


Accepted Solutions
Solution
‎04-07-2015 07:20 PM
Grand Advisor
Posts: 17,396

Re: What is your InnerJoin?

You didn't do anything wrong per se, but one or both of your files has duplicate records for that guestnumber which results in the duplicates.

If that's not what you expected, you should probably deal with that first.

View solution in original post


All Replies
Solution
‎04-07-2015 07:20 PM
Grand Advisor
Posts: 17,396

Re: What is your InnerJoin?

You didn't do anything wrong per se, but one or both of your files has duplicate records for that guestnumber which results in the duplicates.

If that's not what you expected, you should probably deal with that first.

Frequent Contributor
Posts: 104

Re: What is your InnerJoin?

Thank you.  You solved my problem.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 247 views
  • 0 likes
  • 2 in conversation