Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

I'd like to select a customer that never made a sale

 
Jacky Luk
Ranch Hand
Posts: 634
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator


As you see, if the customer never made a sale, the resultset will not be
included, how can I make it included?
Thanks
Jack
 
Martin Vajsar
Sheriff
Posts: 3752
62
Chrome Netbeans IDE Oracle
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
An outer join should do the trick again, as it did here.

This time it is a bit more complicated, since you need to combine inner and outer joins in your query. I'd suggest googling combining inner and outer join.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic