aspose file tools*
The moose likes JDBC and the fly likes I'd like to select a customer that never made a sale Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "I Watch "I New topic
Author

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

Jacky Luk
Ranch Hand

Joined: Aug 02, 2012
Posts: 601


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

Joined: Aug 22, 2010
Posts: 3611
    
  60

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.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: I'd like to select a customer that never made a sale