sql删除多表和多表查询

# 查看账号的客户表a认证状态和表b认证资料结果状态
SELECT
    a.status,b.status
FROM
    table1 a ,table2 b
WHERE a.cstno = b.cstno
AND a.email = 'xxxxxx@.xx.com'

 

#修改客户表和认证表的认证状态    
UPDATE table1 a
LEFT JOIN table2 b ON a.cstno = b.cstno 
SET a.status = '1',
b.status = '2'
WHERE
    a.email = 'xxxxx@xx.com'