This should be enough to get you on the right track.
SELECT dummy
FROM DUAL
WHERE (dummy = 'A' AND dummy NOT IN (11, 12))
OR
(dummy = 'B' AND dummy NOT IN (11, 41));
On Mon, Sep 12, 2011 at 11:56 AM, JK <[email protected]> wrote:
> I am having difficulty in querying in a certain way. This is what I
> would like to do..
>
> select MC_NUMBER
> from TEST
>
> when PART_A_OR_PART_B = 'A'
> then TRANSACTION_CODE not in (11, 17, 20, 41)
> and MBS_CODE in (44,46,51)
>
> when PART_A_OR_PART_B = 'B'
> then TRANSACTION_CODE in (11, 41)
> and MBS_CODE in (15,20)
>
> Any help will be appreciated. Thanks.
>
>
> I have as follows:
>
> CREATE TABLE MYUSER.TEST
> (
> MC_NUMBER VARCHAR2(4 BYTE),
> PART_A_OR_PART_B CHAR(1 BYTE),
> TRANSACTION_CODE NUMBER(3),
> MBS_CODE NUMBER(2)
> );
>
>
> INSERT INTO MYUSER.TEST(MC_NUMBER,
> PART_A_OR_PART_B,TRANSACTION_CODE,MBS_CODE)
> VALUES('2121','A',11,51);
>
> INSERT INTO MYUSER.TEST(MC_NUMBER,
> PART_A_OR_PART_B,TRANSACTION_CODE,MBS_CODE)
> VALUES('2222','A',17,46);
>
> INSERT INTO MYUSER.TEST(MC_NUMBER,
> PART_A_OR_PART_B,TRANSACTION_CODE,MBS_CODE)
> VALUES('4646','A',23,44);
>
> INSERT INTO MYUSER.TEST(MC_NUMBER,
> PART_A_OR_PART_B,TRANSACTION_CODE,MBS_CODE)
> VALUES('4444','A',20,53);
>
> INSERT INTO MYUSER.TEST(MC_NUMBER,
> PART_A_OR_PART_B,TRANSACTION_CODE,MBS_CODE)
> VALUES('6666','B',11,20);
>
> INSERT INTO MYUSER.TEST(MC_NUMBER,
> PART_A_OR_PART_B,TRANSACTION_CODE,MBS_CODE)
> VALUES('3232','B',41,15);
>
> INSERT INTO MYUSER.TEST(MC_NUMBER,
> PART_A_OR_PART_B,TRANSACTION_CODE,MBS_CODE)
> VALUES('8888','B',41,46);
>
> INSERT INTO MYUSER.TEST(MC_NUMBER,
> PART_A_OR_PART_B,TRANSACTION_CODE,MBS_CODE)
> VALUES('9999','B',43,20);
>
> COMMIT;
>
> --
> You received this message because you are subscribed to the Google
> Groups "Oracle PL/SQL" group.
> To post to this group, send email to [email protected]
> To unsubscribe from this group, send email to
> [email protected]
> For more options, visit this group at
> http://groups.google.com/group/Oracle-PLSQL?hl=en
>
--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
