Using the GROUP BY changes this, and the query will attempt to return one record for each "towar" value that matches the selection criteria; since there are none, no records are returned. When using a COUNT(*) and a GROUP BY together, one normally includes the GROUP BY column(s) in the list of columns to be returned.
Yes, now I've got the idea. Thanks!
-- Best regards, Adam http://squadd.sourceforge.net/
