Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CASE WHEN R.CAMPUS = 'A' THEN R.NETID ELSE NULL END AS "A_NETID",
- CASE WHEN R.CAMPUS = 'B' THEN R.NETID ELSE NULL END AS "B_NETID",
- CASE WHEN R.CAMPUS = 'C' THEN R.NETID ELSE NULL END AS "C_NETID",
- CASE WHEN R.CAMPUS = 'D' THEN R.NETID ELSE NULL END AS "D_NETID",
- CASE WHEN R.CAMPUS = 'E' THEN R.NETID ELSE NULL END AS "E_NETID",
- CASE WHEN R.CAMPUS = 'F' THEN R.NETID ELSE NULL END AS "F_NETID",
- CASE WHEN R.CAMPUS = 'G' THEN R.NETID ELSE NULL END AS "G_NETID"
Add Comment
Please, Sign In to add comment