UNION ALL与INNER JOIN同时使用的SQL

{{ time }}

如下

(SELECT a.id,a.username,a.nick_name,r.role_name
FROM coding_admin AS a
INNER JOIN coding_admin_role AS r
ON r.id=a.role_id)
UNION ALL
(SELECT u.id,u.username,u.nick_name,r.role_name
FROM coding_user AS u
INNER JOIN coding_admin_role AS r
ON r.id=u.role_id)