MySQL writes queries and asks for help?

Table T_USER

clipboard.png

T_ROLE

clipboard.png

:

clipboard.png

the following is the table creation and data script

drop table if exists T_USER;
CREATE TABLE T_USER(
USER_ID INT,
USER_NAME VARCHAR(25)
);
INSERT INTO T_USER VALUES(1,"USER_A");
INSERT INTO T_USER VALUES(2,"USER_B");

drop table if exists T_ROLE;
CREATE TABLE T_ROLE(
USER_ID INT,
USER_ROLE VARCHAR(25)
);
INSERT INTO T_ROLE VALUES(1,"ROLE_1");
INSERT INTO T_ROLE VALUES(1,"ROLE_2");

ask for help, how to achieve

Mar.02,2021

SELECT u.USER_ID, r.USER_ROLE, u.USER_NAME FROM T_USER u LEFT JOIN T_ROLE r ON u.USER_ID = r.USER_ID;
Menu