Posted by Jerry Stuckle on 11/21/07 17:07

SBmx wrote:
> 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
>
>

You can get more help for MySQL questions in a MySQL newsgroup such as
comp.databases.mysql.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]