CREATE CURSOR test (Id_otdel int, Id_str int, NumStr1 char(50), NumStr2 char (50), id_glaz int, id_pol int, id_rost int)
INSERT INTO test (Id_otdel, Id_str, NumStr1, NumStr2, id_glaz, id_pol, id_rost) VALUES (1, 1, 'Иванов', 'Иван Ивыныч',1,1,1)
INSERT INTO test (Id_otdel, Id_str, NumStr1, NumStr2, id_glaz, id_pol, id_rost) VALUES (1, 1, 'Петров', 'Иван Ивыныч',2,1,2)
INSERT INTO test (Id_otdel, Id_str, NumStr1, NumStr2, id_glaz, id_pol, id_rost) VALUES (1, 1, 'Сидоров', 'Иван Ивыныч',2,2,1)
INSERT INTO test (Id_otdel, Id_str, NumStr1, NumStr2, id_glaz, id_pol, id_rost) VALUES (1, 1, 'Путенков', 'Иван Ивыныч',1,2,2)
INSERT INTO test (Id_otdel, Id_str, NumStr1, NumStr2, id_glaz, id_pol, id_rost) VALUES (1, 2, 'глаза-', 'голубые',0,0,0)
INSERT INTO test (Id_otdel, Id_str, NumStr1, NumStr2, id_glaz, id_pol, id_rost) VALUES (2, 2, 'глаза-', 'карие',0,0,0)
INSERT INTO test (Id_otdel, Id_str, NumStr1, NumStr2, id_glaz, id_pol, id_rost) VALUES (1, 3, 'пол', 'мужской',0,0,0)
INSERT INTO test (Id_otdel, Id_str, NumStr1, NumStr2, id_glaz, id_pol, id_rost) VALUES (2, 3, 'пол', 'женский',0,0,0)
INSERT INTO test (Id_otdel, Id_str, NumStr1, NumStr2, id_glaz, id_pol, id_rost) VALUES (1, 4, 'рост', '170-180',0,0,0)
INSERT INTO test (Id_otdel, Id_str, NumStr1, NumStr2, id_glaz, id_pol, id_rost) VALUES (2, 4, 'рост', '160-170',0,0,0)

SELECT A.NumStr1 as fam, A.NumStr2 as nameotch, ;
B.NumStr1 as glaz, B.NumStr2 as tip_glaz, ;
C.NumStr1 as pol, C.NumStr2 as tip_pol, ;
D.NumStr1 as rost, D.NumStr2 as tip_rost FROM test A ;
left join test B on A.id_glaz=B.id_otdel AND B.id_str=2 ;
left join test C on A.id_pol=C.id_otdel AND C.id_str=3 ;
left join test D on A.id_rost=D.id_otdel AND D.id_str=4 ;
WHERE A.id_str=1  INTO CURSOR result
BROWSE normal

select emp.id, emp.name, emp.age, eye.name eye_color, gender.name gender, height.name height_class
 from employee emp
  left join entity eye on eye.id = emp.eye_id and eye.discriminarot = 'EYE'
  left join entity gender on gender.id = emp.gender_id and gender.discriminarot = 'GEN'
  left join entity height on height.id = emp.height_id and height.discriminarot = 'HGH'