|
|
Posted by SBmx on 11/21/07 16:28
On Nov 21, 5:05 pm, Erwin Moller
<Since_humans_read_this_I_am_spammed_too_m...@spamyourself.com> wrote:
>
> Try using GROUP BY and use HAVING
actually, i looked into subqueries and came up with this:
SELECT name, id FROM countries WHERE id IN (SELECT country FROM
products)
SELECT name, id FROM producttypes WHERE id IN (SELECT type FROM
products WHERE country=$intCountry)
seems to work, but your solution would probably be more backwards
compatible with older mysql versions.
thanks a bunch!
somBoy MX
Navigation:
[Reply to this message]
|