Create templates to quickly answer FAQs or store snippets for re-use.
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 confusing lastname or last_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! :)
We're a place where coders share, stay up-to-date and grow their careers.
We strive for transparency and don't collect excess data.