Firebird 3.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE SAMPLES(
  PID INTEGER,
  RID INTEGER,
  LOGIN_ID VARCHAR(20),
  PW VARCHAR(20),
  EMAIL VARCHAR(25),
  PHONE VARCHAR(20),
  FIRST_NAME VARCHAR(20),
  LAST_NAME VARCHAR(20)
);
CREATE TABLE SAMPLE_DATA(
  PID INTEGER,
  RID INTEGER,
  KEY_NAME VARCHAR(20),
  KEY_VALUE VARCHAR(120)
);
EXECUTE BLOCK AS BEGIN
INSERT INTO SAMPLES VALUES (1,1,'log1','pas1','mail1','tel1','user1','last1');
INSERT INTO SAMPLES VALUES (2,1,'log2','pas2','mail2','tel2','user2','last2');
INSERT INTO SAMPLES VALUES (3,1,'log3','pas3','mail3','tel3','user3','last3');
INSERT INTO SAMPLES VALUES (4,1,'log4','pas4','mail4','tel4','user4','last4');
INSERT INTO SAMPLES VALUES (5,1,'log5','pas5','mail5','tel5','user5','last5');
INSERT INTO SAMPLES VALUES (6,1,'log6','pas6','mail6','tel6','user6','last6');
INSERT INTO SAMPLES VALUES (7,1,'log7','pas7','mail7','tel7','user7','last7');
INSERT INTO SAMPLE_DATA VALUES (1,1,'Gender','Male');
INSERT INTO SAMPLE_DATA VALUES (2,1,'Gender','Male');
INSERT INTO SAMPLE_DATA VALUES (3,1,'Gender','Female');
INSERT INTO SAMPLE_DATA VALUES (4,1,'Gender','Male');
INSERT INTO SAMPLE_DATA VALUES (5,1,'Gender','Female');
INSERT INTO SAMPLE_DATA VALUES (6,1,'Gender','Male');
INSERT INTO SAMPLE_DATA VALUES (7,1,'Gender','Uknkown');
INSERT INTO SAMPLE_DATA VALUES (1,1,'Age','8');
INSERT INTO SAMPLE_DATA VALUES (2,1,'Age','16');
INSERT INTO SAMPLE_DATA VALUES (3,1,'Age','55');
INSERT INTO SAMPLE_DATA VALUES (4,1,'Age','23');
INSERT INTO SAMPLE_DATA VALUES (5,1,'Age','43');
INSERT INTO SAMPLE_DATA VALUES (6,1,'Age','76');
INSERT INTO SAMPLE_DATA VALUES (7,1,'Age','102');
INSERT INTO SAMPLE_DATA VALUES (1,1,'Occp',null);
INSERT INTO SAMPLE_DATA VALUES (2,1,'Occp','Student');
INSERT INTO SAMPLE_DATA VALUES (3,1,'Occp','Plummer');
INSERT INTO SAMPLE_DATA VALUES (4,1,'Occp','Student');
INSERT INTO SAMPLE_DATA VALUES (5,1,'Occp','Accountant');
INSERT INTO SAMPLE_DATA VALUES (6,1,'Occp','Retired');
INSERT INTO SAMPLE_DATA VALUES (7,1,'Occp','Almost dead');
END
28 rows affected

SELECT s.*, Gender, Age, Occp
        FROM SAMPLES s
        LEFT JOIN (SELECT pid, rid, key_value Gender FROM sample_data WHERE key_name='Gender') USING (pid, rid)
        LEFT JOIN (SELECT pid, rid, key_value Age FROM sample_data WHERE key_name='Age') USING (pid, rid)
        LEFT JOIN (SELECT pid, rid, key_value Occp FROM sample_data WHERE key_name='Occp') USING (pid, rid);


PID
RID
LOGIN_ID
PW
EMAIL
PHONE
FIRST_NAME
LAST_NAME
GENDER
AGE
OCCP


1
1
log1
pas1
mail1
tel1
user1
last1
Male
8
null

2
1
log2
pas2
mail2
tel2
user2
last2
Male
16
Student

3
1
log3
pas3
mail3
tel3
user3
last3
Female
55
Plummer

4
1
log4
pas4
mail4
tel4
user4
last4
Male
23
Student

5
1
log5
pas5
mail5
tel5
user5
last5
Female
43
Accountant

6
1
log6
pas6
mail6
tel6
user6
last6
Male
76
Retired

7
1
log7
pas7
mail7
tel7
user7
last7
Uknkown
102
Almost dead

PID	RID	LOGIN_ID	PW	EMAIL	PHONE	FIRST_NAME	LAST_NAME	GENDER	AGE	OCCP
1	1	log1	pas1	mail1	tel1	user1	last1	Male	8	null
2	1	log2	pas2	mail2	tel2	user2	last2	Male	16	Student
3	1	log3	pas3	mail3	tel3	user3	last3	Female	55	Plummer
4	1	log4	pas4	mail4	tel4	user4	last4	Male	23	Student
5	1	log5	pas5	mail5	tel5	user5	last5	Female	43	Accountant
6	1	log6	pas6	mail6	tel6	user6	last6	Male	76	Retired
7	1	log7	pas7	mail7	tel7	user7	last7	Uknkown	102	Almost dead