I got the following query: select s.id,s.name,sum(p.fee) as fee from serie as s inner join race_serie as rs on (rs.serie_id=s.id) inner join races as r on (r.id=rs.race_id) inner join participants as p on (p.race_id=r.id) where s.receipt=1 and p.rider_id=236 and fee > 0 group by s.id order by s.f_date;
which gives me the error: ERROR 1052 (23000): Column 'fee' in where clause is ambiguous Without the 'and fee > 0' the query works fine. mysql> select version(); +----------------+ | version() | +----------------+ | 4.1.8-standard | +----------------+ Is this due to an old version of MySQL? -- Jørn Dahl-Stamnes homepage: http://www.dahl-stamnes.net/dahls/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
