conf/isi/parovi.sql

select distinct citirani_radovi.cr, 
        cited.cr_full, 
        cited.ut 
from citirani_radovi 
left join cited on (citirani_radovi.cr=cited.cr_full) 
order by citirani_radovi.cr 
;

1	select distinct citirani_radovi.cr,
2	cited.cr_full,
3	cited.ut
4	from citirani_radovi
5	left join cited on (citirani_radovi.cr=cited.cr_full)
6	order by citirani_radovi.cr
7	;
8