jeudi 1 octobre 2020

Combine Multiple rows with same value

im trying to make like

id  name    qty
1   item a   3
2   item b   9 
3   item c   7

from

id  name    qty
1   item a   1
1   item a   2
2   item b   3 
2   item b   1 
2   item b   5
3   item c   3
3   item c   4

by using codes like this

$recapout = DB::table('tb_itemsout')
->select(DB::raw('sum(tb_itemsout.qty) as qty'),'tb_itemsout.id','tb_master_item.item_name','tb_itemsout.qty')
->groupBy('tb_itemsout.','tb_master_item.item_name','tb_itemsout.qty')
->join('tb_master_item','tb_itemsout.id','tb_master_item.id')
->orderBy('tb_master_item.id_item','DESC')
->get();

but it doesnt seem to work. it keeps shows up like

this

id  name    qty
1   item a   1
1   item a   2
2   item b   3 
2   item b   1 
2   item b   5
3   item c   3
3   item c   4


via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire