I've been in an argument with one of our devs that took an update statement with an inner join and made it a left join (because inner was missing some records somehow in the left table - tableB in ...

inner join calendar_t cal on cal.week_id = wh.week_period inner join fiscal_year_t fy on fy.fiscal_year_id = wh.fiscal_year_id and fy.fiscal_year = cal.fiscal_year ...