Re: FN-FORUM: Sql query help

date posted 13th January 2004 14:55

> SELECT
> SUM( IF(i.barcode IS NULL,1,0) ) AS count,
> s.*
> FROM
> item AS i,
> supplier AS s
> WHERE
> i.id_supplier = s.id_supplier
> GROUP BY
> s.id
>

Although it won't this list all suppliers will it ? It'll skip suppliers
with no products - although I appreciate this probably won't happen ;)

Andy