I am working on a page that will display a list of manufacturers that we have
available. I want to check against the products table to verify if a
manufacturer has products in the database or not. I do not want any information
from the products table, only to return a count or boolean if products exist.
Is there a better way to do this?
Please see the SQL statement and related error it is returning.
select manufacturers.id, manufacturers.company, manufacturers.[url],
products.count(*) FROM manufacturers LEFT JOIN products ON
manufacturers.company=products.manfname ORDER BY manufacturers.company
Microsoft OLE DB Provider for SQL Server error '80040e14'