Select problem - Is this possible?

[Michael Pryfogle]

I am currently working on a reporting tool. We store extra repeating information in a bulk table (e), and the non-repeating information in the customer table (c).

I want to get the join of

Query1:
SELECT c.name
FROM c
INNER JOIN c ON c.id=e.c_id
WHERE e.type='23'
AND e.description IS NOT NULL

Query2:
SELECT c.name
FROM c
INNER JOIN c ON c.id=e.c_id
WHERE e.type='24'
AND e.description IS NOT NULL

I want to select the join of customer names were they have both extra type=23 and extra type=24 and both descriptions as not null.

table e
------------------------------
id | c_id | type | description
------------------------------

table c
---------------------
id | name | email
---------------------




Edited 2 time(s). Last edit at 06/24/2005 09:27AM by Michael Pryfogle.