UPDATE tb_data SET audit_time=NOW()
WHERE id =(
select id from (
SELECT b.id FROM tb_area a INNER JOIN tb_data b ON a.id=b.id WHERE a.id=171 AND b.account='***'
) as c
)
UPDATE tb_data SET audit_time=NOW()
WHERE id =(
select id from (
SELECT b.id FROM tb_area a INNER JOIN tb_data b ON a.id=b.id WHERE a.id=171 AND b.account='***'
) as c
)