gistfile1.sql

SELECT  au.numero,tau.descrizione
    FROM DATILINCE.aziendA a ,DATILINCE.infoeco i, DATILINCE.automezzi au,DATILINCE.tipo_automezzi tau
    WHERE a.id_lince=943788
    and a.data_annullamento is null
    and i.data_annullamento is null
    and a.id_lince=i.id_lince
    and i.cd_infoeco=au.cd_infoeco
    and au.cd_tipo_automezzi=tau.cd_tipo_automezzi