SQL删除使用别名问题

MySQL执行delete操作时若想使用别名，别名必须在delete之后出现一次

delete <alias> from <table> <alias> where <alias>.<field>...

比如：

DELETE brr
FROM
  base_role_resource brr 
  LEFT JOIN base_role br 
    ON br.id = brr.role_id 
WHERE role_id NOT IN 
  (SELECT 
    br.id 
  FROM
    base_role br 
  WHERE br.create_time < '2017-01-07 16:28:47')

SQL Server 与 Oracle 则没有这种限制