This is my first post and I'm not sure if I posted to the right category. I've been looking for some online examples that explain the use of LEFT JOIN and RIGHT JOIN. As a beginner I don't quite understand these two types of outer joins.
According to my understanding, LEFT (or RIGHT) JOIN seems to select all records from the left (or right) table regardless of whether those records meet the specified condition. Is my understanding wrong? Appreciate it if you could share some online resources to explain.