Display only one

[shaleen7]

I'm tryiing to exclude cases where a certain criteria
only exists.

For example:
Each application has several cases in it.
Application number: APP100 contains the following cases:
State Type
NY PCT
NJ PSP
PA NP

OR
Application number: APP101 contains the following:
State Type
MI PSP
PA NP

OR

Application number: APP102 contains the following:
State Type
CA PSP

I need to come up with a query where I exclude an application number where a PSP case only exists within the application number. Like APP102 shown above.

Here is my select statement:
SELECT Tableapp,Tabletype
FROM Tableapp, Tabletype,tablepatents
WHERE Tableapp.ideapp= tablepatents.ideapp and Tabletype.idetyp = tablepatents.idetyp
AND Tabletype.CODTYP = 'PSP'

Any suggestions?

 

[SantaMufasa]

Shaleen,

Yes, we can certainly create a working solution for you. Since I'm a bit cramped on time this morning, could you please post the following to speed things along:

1) CREATE TABLE...statements for your three tables.
2) INSERT...statements into those tables to create enough data to test/exercise the code.

As soon as you post the code, I'll set about creating solution code for you.

Mufasa
(aka Dave of Sandy, Utah, USA @ 16:52 (25Jun04) UTC (aka "GMT" and "Zulu"), 09:52 (25Jun04) Mountain Time)