ERPstuff - Oracle EBS Community

<b>Class TABLE</b>

SNO
TNO
MARKS
GRADE


<b>TERM TABLE</b>

TNO
TERM
TERMSTATUS

<b>SELECT * FROM TERM</b>

TNO TERM TS
--- ---------- ---
26 SPRING 2006
27 SUMMER 2006
28 FALL 2006
0 EXEMPTIONS
29 SPRING 2007
30 SUMMER 2007
31 FALL 2007
32 SPRING 2008 C

<b>Query is </b>
SELECT C.SNO, T.TERM, C.MARKS, C.GRADE
FROM CLASS C, TERM T
WHERE T.TNO = C.TNO;

SNO TNO MA GR
--- --- -- --
1888 26 91 A
1888 26 49 F
1888 27 61 C
1888 27 86 A
1888 28 81 B+
1888 28 85 A
1888 28 82 B+
1888 28 83 B+
1888 29
1888 29 75 B
1888 30
1888 30


I want a Condition that if the TERMSTATUS IS 'C' MARKS not shown in the Result but SNO, TNO were shown like this
SNO TNO MA GR
--- --- -- --
1888 26 91 A
1888 26 49 F
1888 27 61 C
1888 27 86 A
1888 28 81 B+
1888 28 85 A
1888 28 82 B+
1888 28 83 B+
1888 29
1888 29
1888 30
1888 30

Please Help me in this Query


Thanks

Cheers

aoa najm

use this senario (decode) may be it helps u

select ename,job,decode(job,'CLERK',null,sal) sal
from emp

regards

zafar iqbal

You can use case statment

Assalam-o-Alaikum

Dear Najm,

Sorry for late reply,


SELECT C.SNO, T.TERM,
DECODE(C.GRADE, 'C', TO_NUMBER(NULL), C.MARKS) MARKS,
C.GRADE
FROM CLASS C, TERM T
WHERE T.TNO = C.TNO;


hope it will solve it


Regards
Rehan Mirza