select orderid,product,mcid,SUM(sq) as sq,SUM(qty) as qty from OrdersDetail group by orderid,product,mcid
Code (SQL)
select orderid,product,mcid,SUM(sq) as sq,SUM(qty) as qty,dateS,timeS,dateN,timeN from OrdersDetail group by orderid,product,mcid,dateS,timeS,dateN,timeN