1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
| insert into compatible(id_2, id_1) values (10, 5);
insert into compatible(id_2, id_1) values (10, 8);
insert into compatible(id_1, id_2) values (10, 12);
insert into compatible(id_1, id_2) values (10, 14);
create view lst_compat
as ( select id_1, id_2 from compatible
union all
select id_2, id_1 from compatible
)
;
select id_1, id_2
from lst_compat
where id_1 = 10
;
id_1 id_2
10 5
10 8
10 12
10 14
select id_1, id_2
from lst_compat
where id_1 = 8
;
id_1 id_2
8 10 |
Partager