

select TB_B_ACCOUNT.ACCOUNT_NAME, TB_B_USER.PASSWORD from TB_B_ACCOUNT
inner join TB_B_USER on TB_B_ACCOUNT.USER_ID=TB_B_USER.ID
where TB_B_ACCOUNT.IDENTITY_TYPE_ID='T01'
  and TB_B_ACCOUNT.ACCOUNT_EXPIRY_DATE is null
  and TB_B_ACCOUNT.STATE='NORMAL'


update TB_B_ACCOUNT
set ACTIVATION=1