[lms] przedplaty klienta - blad bazy

Napotkano błędy w bazie danych! Zapytanie: SELECT invoiceid, itemid, MIN(cdate) AS cdate, SUM(CASE type WHEN 3 THEN value ELSE value*-1 END)*-1 AS value FROM cash LEFT JOIN invoices ON (invoiceid = invoices.id) WHERE customerid = '129' AND invoiceid > 0 AND itemid > 0 GROUP BY invoiceid, itemid HAVING SUM(CASE type WHEN 3 THEN value ELSE value*-1 END)*-1 > 0 ORDER BY cdate Błąd: Column: 'customerid' in where clause is ambiguous

Wersja LMS: 1.7-cvs (1.681/1.9) Wersja LMSDB: 1.7-cvs (core: 1.35 / driver: mysql 1.33) Wersja MySQL: 4.0.24_Debian-9-log Wersja PHP: 4.3.10-15 Wersja Smarty: 2.6.9

jakies sugestie ? Robert CyberM