Good to know I'm not missing anything obvious. This is what I came up with as a workaround. I'm very new with SQL so I'm sure it can be optimized.