4 ms·
Do Right Joins even matter?
- andrewfromx 4y agoDon't you feel dirty as a developer ever doing _any_ join because you know at scale someone will have to undo this join and break it apart between two services? OR, should we accept that some projects will never get to that scale and just go ahead and join! It's like we are plumbers and sometimes we work on small houses and sometimes huge skyscrapers but every small house thinks they are going to sky scrape some day soon.
- inphovore 4y agoYes, it keeps nulls from appearing on important fields. Left join included nulls from the right. Right join excluded omissions. Though admittedly one might find alternative conditions for similar behavior.