Hi all,

I have this SELECT Statement,

SELECT distinct c_cod_art, c.c_descri, b.c_nome, 
SUM (CASE WHEN d.n_ent_sai =  1 THEN n_quant_1 ELSE 0 END)  as ENT,
SUM (CASE WHEN d.n_ent_sai =  2 THEN n_quant_1 ELSE 0 END)  as SAI
from tbl_gc_movimentosstk a 
left join tbl_gc_Artigos c on c.c_codigo=a.c_cod_art
group by c_cod_art, c.c_descri, b.c_nome
order by c_cod_art

and it gives two rows for the same c_cod_art, one for ENT, and one for SAI, any chance to join them only in one row.


Thanks

João Batista