In our second part of learning how to work with the SQL Join clause, we will focus on the Outer Joins. The first part, where we talk about Inner Jo...
For further actions, you may consider blocking this person and/or reporting abuse
Great article. However, in the full outer join example, you should give a better description of what a full outer join will do in the context of your vet example.
Let's say we want to know which doctor checked our pets, and the date they were seen.
I would not use full outer join but a left join instead.
Thank you for your feedback! :)
This specific example could have better wording, or description as you mentioned. I will revise it tomorrow and edit accordingly.
some critics about naming. Maybe use
doctorname
instead of confusinglastname
orlast_name
.Thanks for sharing good article! 😄
Thank you for the feedback! 😊
TIL MySQL doesn’t support full outer joins?! Whaaaat?
I know, hahaha...
But the good news is that there's always a work-around :)
I love a good outer join! Great article Wendy.
Great idea for a series too, when I first picked up SQL it took me forever to wrap my head around joins. Venn diagrams are the way!!
Thank you for your feedback James!
I'm glad you liked it!
Such a great explanation of the concept. Thanks.
Thank you for you feedback! :)