Funky Select statement

[gixer]

Hi everyone, I need help with a select statement.

records in the details section should have either the iactionid value 117 and 129, or 117 and 37.

A sample looks like this:

icampaignid iactionid
10 117
10 129
11 117
11 37
12 129
13 37

So from the above table there is an error because the icampaignid of 12 and 13 does not have an iactionid of 117 associated with it. How do I find all the icampaignid's that have an iactionid of 37 or 129, but that are missing the iactionid of 117?

Hope this makes sense.

Any help is appreciated!

 

[tlbroadbent]

Here is one possibility.

Select *
From YourTable a
Where Not Exists
(Select * From YourTable
Where icampaignid=a.icampaignid
And iactionid=117) Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[gixer]

Hey thanks very much for the help!