how are manufacturers linked to products in your database?
using different types of joins in your query can achieve the results you are after to join the manufacturers and products table together.
Using a inner join will only return a result if there is a march in both tables. See this page for more details on join queriers:
for details on clearing the search filter, see the following thread: