adding the as ring_code did not work. i still get the error message

select error: sqlstate = 37000

the multi-part identifier "rsr.location_id" could not be bound

i forgot to add the column...