On 20-Mar-2003 Aziz DURMAZ wrote: > > this is my query: > > SELECT urun.`StokKodu`, > urun.`Isim`, > (SUM((depo.EvrakYonu)*depo.Miktar)-SUM((1-depo.EvrakYonu)*depo.Miktar)) > AS > `Mevcut Miktar` > > FROM rootdata.urun AS urun, > seconddata.depohareket AS depo > > > WHERE urun.`ID` = depo.`UrunID` > AND depo.`Iptal` = 0 > AND urun.`HizmetUrunu` = 0 > GROUP BY urun.`ID` > > But i dont want to get a row which `Mevcut Miktar`=0 > > How i can modify my query. >
HAVING `Mevcut Miktar` <> 0 Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. (53kr33t w0rdz: sql table query) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php