Mike Harris Posted April 27, 2023 Share Posted April 27, 2023 Hello! I have two tables containing different information about the same customers. In one table I have all the customers, while in the other I have only the customers who have used some premium services. I wanted to add the services information to the main table, without losing the customers who didn't use the premium services and I used a left-outer join. I expected the resulting table to have the same number of rows as the left table but in reality, there are more and I don't understand why. Thank you! Want to know more? Link to comment Share on other sites More sharing options...
Nicolò Posted May 10, 2023 Share Posted May 10, 2023 Hi Mike, have you checked if the matching attributes are keys of the tables you are joining? Want to know more? Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.