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_artand 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.