/*
Alias: WORK
LiveAnswer: FALSE

*/

select n.denumire, u.denumire, s.stocc, st.serie, st.cant
 from 
"2002_12\stoc" s left outer join "2002_12\stocser" st on s.codstoc = st.codstoc,
"nart"n, "num" u
where 
s.art = n.cod and
n.um = u.cod
