When is inner join used

ValueB 3 TableB. Value b. Value 2 TableA. Value2 2 TableB. ValueB 3 TableA. Value3 3 TableB. Value 1 TableA. Use a full join when you want all the results from both Tables. Scott Scott 1, 1 1 gold badge 21 21 silver badges 45 45 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook.

Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Does ES6 make JavaScript frameworks obsolete? Podcast Do polyglots have an edge when it comes to mastering programming Featured on Meta. Now live: A fully responsive profile. Linked 0. Related You can easily notice that we have 2 new rows in the table country , one for Spain and one for Russia.

Their ids are 6 and 7. Both queries return exactly the same result. This is not by accident but the result of the fact that this is the same query written in two different ways. Both ways are correct, and you can use any of them. In case we forgot to write down this join condition, we would have the Cartesian product of both tables. There are a few reasons for that:. In some cases, we want to have even these records in our results. This image may help you visualize joins as sets:.

This picture really helps answer the question that arises with the given exercise. From my perspective this was the incongruency with having both lefts and rights. Thanks for explaining with a real life example. Thankyou for explaining with a Practical Life Example. Thank you for this answer, but one minor addition. Thanks for your help mate dsonigladiator.

Have a nice one.