Re: Select problem - Is this possible?

[Michael Pryfogle]

Thanks for the help,
I think i finally have it figured out

- there is only one e.type=23 or 24 per c.id

SELECT c.name
FROM c INNER JOIN e
ON c.id = e.c_id
WHERE
(
e.type =23
AND e.description IS NOT NULL
)
OR
(
e.type =24
AND e.description IS NOT NULL
)
GROUP BY c.id
HAVING count( c.id ) >=2


This way I can have it select other options besides IS NOT NULL and it should still work I believe, I'll have to test it out some more.