主表和子表的 assessid 这个值 一 一对应
主表一条记录,子表多条记录
皆删(无外键)
DELETE a,d from by_risk_assess_master a JOIN by_risk_assess_detail d on a.assess_id = d.assess_id where a.assess_code = ‘0013’ and a.assess_id = ‘539c6aab4fb1438a94ccf0114969365c’
DELETE a,d from by_risk_assess_master a JOIN by_risk_assess_detail d on a.assess_id = d.assess_id where a.assess_code = '0013' and a.assess_id = '539c6aab4fb1438a94ccf0114969365c'