BTW, personally I would find it much more intuitive to work from the left-hand side, where that one would be the one where I'd expect to have more new rows. In your case that would be the HAL table, since there could be new doctors, so HAL would be in my FROM clause and DR in the LEFT OUTER JOIN.