| 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 |