• Like this???

    Select SX.Status

     From StatusXref SX

     join ITRegInfo ITRI

     on SX.StatusId = ITRI.Status

    Steve