test

Sql code posted by Noob
created at 30 Sep 14:57, updated at 30 Sep 19:20

Edit | Back 
1
2
3
4
5
6
7
 
SELECT ad.key_id,nume_id01,nume_id02,docu_tipo,docu_path, ad.inse_data, v.master, v.codi_veic_id, v.targa, p.key_pratica, p.inse_data
from Archiviazione_Documentale ad
inner join veicolo v on ad.nume_id01 = v.master
left  join pratica p on p.codi_veic_id = v.codi_veic_id
where nume_id02 = 0 and docu_tipo in(3,44)
and p.key_pratica is not null
order by v.master, v.codi_veic_id,ad.inse_data
397 Bytes in 2 ms with coderay