Jump to content

Left-outer Join


Mike Harris

Recommended Posts

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!

Link to comment
Share on other sites

  • 2 weeks later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...