Table T_USER
T_ROLE
:
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