Predmet:Re: MySQL upiti nad jednom tablom

---

Pisao napamet, iz glave, nisam testirao.

Ovo provereno radi

select t1.datum, t1.kg, t1.voce
from ProdajaVoca As t1
left join ProdajaVoca As t2 on t1.datum = t2.datum AND t1.kg = t2.kg
where t2.voce = 'jabuka' OR (t1.voce='jabuka' AND t1.kg is null);