create table entsal (
nombreS char,
referencia char,
tea numeric
);
create table salidas(
vin char,
estado char,
referencia char
);
insert into entsal values('h','a',1);
--insert into entsal values('b','a',1);
--insert into entsal values('u','a',1);
--insert into entsal values('o','a',1);
insert into entsal values('a','b',1);
--insert into entsal values('b','b',1);
--insert into entsal values('c','b',1);
--insert into entsal values('d','b',1);
insert into salidas values('z','a','a');
insert into salidas values('d','a','b');
insert into salidas values('a','a','b');
insert into salidas values('e','a','a');
insert into salidas values('r','a','z');
select * from entsal inner join salidas ON entsal.referencia = salidas.referencia;
Y3JlYXRlIHRhYmxlIGVudHNhbCAoCiAgbm9tYnJlUyBjaGFyLAogIHJlZmVyZW5jaWEgY2hhciwKICB0ZWEgbnVtZXJpYwopOwoKY3JlYXRlIHRhYmxlIHNhbGlkYXMoCiAgdmluIGNoYXIsCiAgZXN0YWRvIGNoYXIsCiAgcmVmZXJlbmNpYSBjaGFyCik7CgppbnNlcnQgaW50byBlbnRzYWwgdmFsdWVzKCdoJywnYScsMSk7Ci0taW5zZXJ0IGludG8gZW50c2FsIHZhbHVlcygnYicsJ2EnLDEpOwotLWluc2VydCBpbnRvIGVudHNhbCB2YWx1ZXMoJ3UnLCdhJywxKTsKLS1pbnNlcnQgaW50byBlbnRzYWwgdmFsdWVzKCdvJywnYScsMSk7CgppbnNlcnQgaW50byBlbnRzYWwgdmFsdWVzKCdhJywnYicsMSk7Ci0taW5zZXJ0IGludG8gZW50c2FsIHZhbHVlcygnYicsJ2InLDEpOwotLWluc2VydCBpbnRvIGVudHNhbCB2YWx1ZXMoJ2MnLCdiJywxKTsKLS1pbnNlcnQgaW50byBlbnRzYWwgdmFsdWVzKCdkJywnYicsMSk7CgppbnNlcnQgaW50byBzYWxpZGFzIHZhbHVlcygneicsJ2EnLCdhJyk7Cmluc2VydCBpbnRvIHNhbGlkYXMgdmFsdWVzKCdkJywnYScsJ2InKTsKaW5zZXJ0IGludG8gc2FsaWRhcyB2YWx1ZXMoJ2EnLCdhJywnYicpOwppbnNlcnQgaW50byBzYWxpZGFzIHZhbHVlcygnZScsJ2EnLCdhJyk7Cmluc2VydCBpbnRvIHNhbGlkYXMgdmFsdWVzKCdyJywnYScsJ3onKTsKCnNlbGVjdCAqIGZyb20gZW50c2FsIGlubmVyIGpvaW4gc2FsaWRhcyBPTiBlbnRzYWwucmVmZXJlbmNpYSA9IHNhbGlkYXMucmVmZXJlbmNpYTs=