Advertisement
Guest User

Untitled

a guest
Mar 24th, 2017
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.23 KB | None | 0 0
  1. SELECT
  2. u0.LOGIN AS USERNAME,
  3. u0.PASSWORD_SHA256 AS PASSWORD,
  4. r0.CODE AS ROLE
  5. FROM USERS u0
  6. LEFT JOIN USERS_ROLES ur0 ON u0.U_ID = ur0.USER_ID
  7. JOIN ROLES r0 ON ur0.ROLE_ID = r0.R_ID
  8. WHERE u0.LOGIN = 'USoliyev';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement