sql server - SQL Update Left Join - however if no records put 0 in ...

UPDATE P SET activityTempBookings = t.bookingTempTotal FROM ... use COALESCE which basically returns the first nonnull expression ...

stackoverflow.com