Hi,

I am quite new to SQL and working on self-joins but not able to get an answer to this query.

In the table there 4 columns as below...

Number Status Plan_INST
123 AC GSM
345 DP GPRS
345 AC GSM

AC = Active
DP = Deactivate Permanently

The table contains thousands of "Numbers". And I want a list of those whose "Status" is AC and have got only GSM, and not GPRS. So either status of GPRS should be DP or it's not associated with the Number.

Thanks in advance.
Kapil...