-
Self-Join in a table
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...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|