<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
Help Required in a Query
-
- Posts: 22
- Joined: Sat Dec 16, 2006 6:35 am
- Location: Pakistan
-
- Posts: 22
- Joined: Sat Dec 16, 2006 6:35 am
- Location: Pakistan
-
- Posts: 132
- Joined: Sun Apr 02, 2006 10:36 am
- Location: Pakistan
Who is online
Users browsing this forum: No registered users and 19 guests