Mostrar datos de una tabla dependiendo de otra

[ut261c]

Iniciado por ut261c

-- consulta
select tt1.*
from t1 tt1
join t3 tt3
on tt1.id_cal = tt3.id_cal
join t2 tt2
on tt2.id_empresa = tt3.id_empresa
where tt3.id_empresa = 'EM3';

-- en la tabla3 la clave primaria es -> primary key(claveT1, claveT2)
-- ------------------------------------------------------
-- ------------------------------------------------------
-- ------------------------------------------------------

-- bd
create table t1(
id_cal char(3) primary key,
startday date,
endday date,
route varchar(30),
destination varchar(30),
description varchar(30)
);

create table t2(
id_empresa char(3) primary key,
nombre varchar(30),
direccion varchar(30)
);
create table t3(
id_cal char(3),
id_empresa char(3),
primary key(id_cal, id_empresa)
);

insert into t1 values
('TA1','2017-01,01','2017-03-03','AAA','OOO','ABC'),
('TA2','2017-01,01','2017-03-03','III','daf','54g'),
('TA3','2017-01,01','2017-03-03','EEE','fdf','f3f');


insert into t2 values
('EM1','CardCard','Los cuadrados 333'),
('EM2','OliverA','Los triangulos 333'),
('EM3','Samsemsim','Los rectangulos 333');

insert into t3 values
('TA1','EM1'),('TA3','EM3'),('TA2','EM2');

select tt1.*
from t1 tt1
join t3 tt3
on tt1.id_cal = tt3.id_cal
join t2 tt2
on tt2.id_empresa = tt3.id_empresa
where tt3.id_empresa = 'EM3';

insert into t1 values
('TA4','2017-01,01','2017-03-03','AAA','OOO','ABC');

insert into t3 values
('TA4','EM3');
-- -----------------------