Please check below the query and result but not solved this problem.( database SQL-2014)

Select al.login_id"Login ID",au.first_name"Name",

al.name"Login Name" from aaaauthorizedrole aar left join aaarole ar on aar.role_id=ar.role_id left

join aaaaccount aa on aar.account_id=aa.account_id left join aaalogin al on aa.login_id=al.login_id left

join aaauser au on al.user_id=au.user_id left join sduser sd on au.user_id=sd.userid where ar.name like

'SDAdmin' and sd.status='ACTIVE';

Result :

Login ID   Name              Login Name

2              Administrator     administrator

324         Khalid Mahmud   khalid.m

1812       Habibur Rahman Arman                arman.h

4656       Zahiruddin             zahir.k

update AaaPassword set password='admin123',

--SALT=pgp_sym_encrypt('admin123'),

 algorithm='bcrypt' where password_id in (select ap.password_id from aaaaccpassword ap

 left join aaaaccount ac on ac.account_id=ap.account_id

  left join aaalogin al on al.login_id=ac.login_id where al.login_id= 2);

Result :

(1 row(s) affected)