Predmet:Re: MySQL upiti nad jednom tablom

---

A odakle ti podaci o sutrasnjoj prodaji? Da nisi mozda vidovit

SELECT t1.datum, t1.kg, t1.voce
FROM prodaja AS t1
INNER JOIN prodaja AS t2
ON t1.kg = t2.kg AND t1.datum = t2.datum
WHERE trim(t2.voce)='jabuka' AND (trim(t2.kg) <> '0' OR trim(t1.voce)='jabuka') AND t1.datum>=curdate()
ORDER BY t1.datum
LIMIT 1000