Dear All,

I have these two queries which are supposed to return the same results
for the fields with the same name (ex query 1 sum1 = query 2 sum1):
 
The first query gives me back the correct result for the sum():
 
SELECT           DATE_FORMAT(ordini.dataord,'%d-%m-%Y') date1, 
                 SUM(ordini.totale) sum1,
                 SUM(ordini.quantita) sum2,
                 ordini.cod,
                 ordini.fromprev
 FROM            ordini
 WHERE           ordini.numordine = 2302 
 GROUP BY        ordini.numordine;

+------------+---------+------+------------+----------+
| date1      | sum1    | sum2 | cod        | fromprev |
+------------+---------+------+------------+----------+
| 29-05-2003 | 436.498 |   10 | SC0001GP   |     2666 |
+------------+---------+------+------------+----------+ 
 
this other one gives me problems with the sum(), wrong result.

SELECT           DATE_FORMAT(ordini.dataord,'%d-%m-%Y') date1, 
                 SUM(ordini.totale) sum1,
                 SUM(ordini.quantita) sum2,
                 ordini.cod,
                 ordini.fromprev,
                 carello.numprev,
                 DATE_FORMAT(carello.dataordine,'%d-%m-%Y') date2 
FROM             ordini, carello 
WHERE            ordini.numordine = 2302 
AND              carello.numprev = ordini.fromprev 
GROUP BY         ordini.numordine, carello.numprev;

+------------+----------+------+---------+----------+---------+---------
---+
| date1      | sum1     | sum2 | cod     | fromprev | numprev | date2
|
+------------+----------+------+---------+----------+---------+---------
---+
| 29-05-2003 | 3491.984 |   80 | SC0001GP|     2666 |    2666 |
28-05-2003 |
+------------+----------+------+---------+----------+---------+---------
---+
 
Help is required.
I run Mysql 4.0.13

Thanks
Patrizio




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to