假设有三张表:t_traval_detail,t_todo ,t_bill_class
目的:我要删除t_traval_detail表中符合d.SYSUSER = 'li_tao' 和d.CREATEDATE LIKE '20180201113205%'的三张表中所有相关的数据,
DELETE d,t,c
FROMt_traval_detail d
LEFT JOIN t_todo t ON d.UNICODE = t.TDCODE
LEFT JOIN t_bill_class c ON d.UNICODE = c.UNICODE
WHERE
d.SYSUSER = 'li_tao'
AND d.CREATEDATE LIKE '20180201113205%'