SELECT
a.role_id,a.account_name
FROM
account AS a
INNER JOIN role AS r ON a.role_id = r.role_id;
转载于:https://www.cnblogs.com/17003WS/p/6804879.html
SELECT
a.role_id,a.account_name
FROM
account AS a
INNER JOIN role AS r ON a.role_id = r.role_id;
转载于:https://www.cnblogs.com/17003WS/p/6804879.html