Roman,
Wednesday, September 04, 2002, 10:47:18 AM, you wrote:
RM> Server info:
RM> Release: mysql-3.23.52 (Official MySQL RPM)
RM> Server: /usr/bin/mysqladmin Ver 8.23 Distrib 3.23.52, for pc-linux-gnu on i686
RM> Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
RM> Thi
Roman,
try to execute this query:
select e.cid,d.amount,dd.amount
from eee e
left join ddd d on (d.cid=e.cid and d.c>=2 and d.c<=3)
left join ddd dd on (dd.cid=e.cid and dd.c=3)
and after that try to group by them manualy. What do you have as result?
Best regards,
Mikhail.
- Original Mess
