/*
Alias: WORK
LiveAnswer: FALSE

*/

select n.denumire as articol , g.denumire as Gestiune, u.denumire as um, s.stocc, ns.serie , st.cant
 from
"2002_12\stoc" s left outer join "2002_12\stocser" st on s.codstoc = st.codstoc
 left outer join "nserii" ns on st.serie = ns.Cod,
"nart" n, "num" u,
"ngest" g
where
s.art = n.cod and
n.um = u.cod and
s.gest = g.cod


