which one should I use LEFT or RIGHT outer join

[@jennisonb37]

Great explanation. Makes it so simple.

[@Rebellionrider]

Thank you for the kind words! 😊 I'm glad the explanation made things simple for you. If there's anything more you'd like to delve into or if you have any questions, feel free to ask. Also, curious - do you have a preferred coding environment or IDE? I'd love to hear your thoughts on it! 🌟💻

[@DB2_Oracle]

Amazing. Very nice explanation.

[@Rebellionrider]

Glad you liked it!

[@anshulg619]

If we can get the right join using left with the sequence reversed then what is the significance of creating right join

[@raquelsoares9042]

Thank you! I have a question.How use the Left/Right join using correlation in the tables nd operator (+), in Oracle? Something like c.field = b.field(+).