That is what I did, (finially got it to work)
For the distinct, I was Trying about any thing ! ..

the actual solution was :

SELECT Orders.Ord_id,
format(Sum(detOrders.detCmd_Qte*detOrders.detCmd_Price),'standard') AS
TotalGross,
format(Sum((detOrders.detCmd_Qte*detOrders.detCmd_Price)*(100-detcmd_discount)/100),'standard')
AS TotalNet,
Orders.Cst_id, Orders.Ord_Date, Orders.Ord_Accepted, Orders.Ord_Printed,
Orders.Ord_Proforma, Orders.Ord_ProformaPrinted, Orders.Devise_id,
Orders.Taxes_id, Orders.Ord_Comments, Orders.Ord_PrintComment,
Orders.Ord_PaymentTerms, Orders.ord_ShippingFeeBase,
Orders.ord_ShippingFeeExtra
FROM detOrders
RIGHT JOIN Orders ON detOrders.Ord_id=Orders.Ord_id
WHERE(Orders.cst_ID = 1)
GROUP BY Orders.Ord_id, Orders.Ord_Date, Orders.Ord_Accepted,
Orders.Ord_Printed, Orders.Ord_Proforma, Orders.Ord_ProformaPrinted,
Orders.Ord_Comments, Orders.ord_ShippingFeeBase,
Orders.ord_ShippingFeeExtra;