Hi ,
I have this SQL code
and the result isSELECT hareketler_siparis_icin_aciklar_birikimli_miktarli.stokid, hareketler_siparis_icin_aciklar_birikimli_miktarli.markaid, acik_siparis, index_teslimat_tarihi FROM hareketler_siparis_icin_aciklar_birikimli_miktarli WHERE hareketler_siparis_icin_aciklar_birikimli_miktarli.stokid = '7436' and hareketler_siparis_icin_aciklar_birikimli_miktarli.markaid = '444' and tipid = 24 and markaid > -1
SQL-Code.png
How can i sum the column acik_siparis and also show date 2018-02-09 only ?
Mean
SQL-Code-2.png
If you can Please help me on this subject . thanks for your effort and your time.
Regards.




