Posted by SBmx on 11/21/07 16:06

hello

I need help building a SELECT query... well, two queries actually

i have three tables:

products / fields id, name, type, country
producttypes / fields: id, name
countries / fields: id, name

as you probably guessed, products.type stores a value from
producttypes.id and products.country stores a value from countries.id

now, in my first query i need to select all producttypes that have
more than 0 products belonging to that category.

in a subsequent query i'll have to select all countries that have more
than 0 products which belong to a given producttype.

Thanks for taking the time to help me solve this one..

somaBoy MX

• Next in forum: SOAP on php v5.2.4
• Prev in forum: Re: [SQL] need help on a mysql query
• Thread view: [SQL] need help on a mysql query

[Reply to this message]