ejemplo para SOes, PostgreSQL

Language: Layout:

--PostgreSQL 9.6
--'\\' is a delimiter

create table tipovehiculo(
    idtipo integer,
    marca character varying(50),
    modelo character varying(50)
    );
    
insert into tipovehiculo values(22, 'seat', 'ibiza');
    
create table vehiculoflota(
    idmatricula character varying(50),
    idtipo integer,
    idnombreempresa character varying(50),
    disponibilidad character varying(20)
    );
    
insert into vehiculoflota values('locamatricula', 22, 'juguetos', 'Si');
insert into vehiculoflota values('33333', 22, 'yoqse', 'Si');
insert into vehiculoflota values('matriculayop', 22, 'filomena', 'Si');
    
create table empresa(
    idnombreempresa character varying(50)
    );
    
insert into empresa values('juguetos');
insert into empresa values('yoqse');
insert into empresa values('filomena');

SELECT * 
        FROM TipoVehiculo
        INNER JOIN VehiculoFlota
        ON VehiculoFlota.idtipo=TipoVehiculo.idtipo
        INNER JOIN Empresa 
        ON Empresa.idnombreempresa=VehiculoFlota.idnombreempresa
        WHERE disponibilidad LIKE 'Si';


absolute service time: 0,42 sec