| 刘洪青 | 4720585 | 2020-08-14 13:39:30 +0800 | [diff] [blame^] | 1 | |
| 2 | |||||
| 3 | select TB_B_ACCOUNT.ACCOUNT_NAME, TB_B_USER.PASSWORD from TB_B_ACCOUNT | ||||
| 4 | inner join TB_B_USER on TB_B_ACCOUNT.USER_ID=TB_B_USER.ID | ||||
| 5 | where TB_B_ACCOUNT.IDENTITY_TYPE_ID='T01' | ||||
| 6 | and TB_B_ACCOUNT.ACCOUNT_EXPIRY_DATE is null | ||||
| 7 | and TB_B_ACCOUNT.STATE='NORMAL' | ||||
| 8 | |||||
| 9 | |||||
| 10 | |||||
| 11 | update TB_B_ACCOUNT | ||||
| 12 | set ACTIVATION=1 | ||||