SELECT     LocId, PhId
FROM         AllMast
WHERE     (AllMastId = 'CS') OR
                      (AllMastId = 'CRS') OR
                      (AllMastId = 'SC')