cari_tarihli_alimlar.sql 208 B

123456
  1. SELECT a.stok_kodu, stok_adi, sum( b.miktar )
  2. FROM sthar AS b
  3. INNER JOIN tblstsabit AS a ON a.stok_kodu = b.stok_kodu
  4. WHERE hedef = '12'
  5. AND tarih between '2015-01-05' and '2015-01-11'
  6. GROUP BY stok_kodu