"PaT!" <[EMAIL PROTECTED]> wrote: > I have this two queries > > The first one gives me the right result for the sum(): > > SELECT DATE_FORMAT(ordini.dataord,'%d-%m-%Y'), > SUM(ordini.totale), > SUM(ordini.quantita), > ordini.codcliente, > ordini.fromprev > FROM ordini > WHERE ordini.numordine = 2302 > GROUP BY ordini.numordine; > > > this other one gives me problems with the sum(), wrong result. > > SELECT DATE_FORMAT(ordini.dataord,'%d-%m-%Y'), > SUM(ordini.totale), > SUM(ordini.quantita), > ordini.codcliente, > ordini.fromprev, > carello.numprev, > DATE_FORMAT(carello.dataordine,'%d-%m-%Y') > FROM ordini, carello > WHERE ordini.numordine = 2302 > AND carello.numprev = ordini.fromprev > GROUP BY ordini.numordine, carello.numprev; > > Help is appreciated
What is wrong with your second query? Please, be more detailed. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
