Chidane
New User
Joined: 25 Nov 2021
Posts: 11
Location: India
|
|
|
|
Hi Team,
Could you please help me in the requirement
The COMPTBL table has 2 fields - CompName, ID
The IDTABLE table has also some fields - ID, ReqtNo, Code
In the WHERE clause, I would like to search B.CODE = 'X', if the value of ReqtNo is 'ABC' else search B.CODE = 'Y' for all other values of ReqtNo column
| Code: |
SELECT COMPNAME FROM COMPTBL A , IDTABLE B
WHERE A.ID = B.ID
AND B.CODE = 'X' (search for this value only if B.REQTNO = 'ABC')
otherwise check for B.CODE = 'Y' (for B.REQTNO <> 'ABC')
|
Appreciate your help.
Thanks
Cdane |
|
sergeyken
Senior Member
Joined: 29 Apr 2008
Posts: 2017
Location: USA
|
|
|
|
I would recommend first to RTFM, and next to post the questions. NOT VICE VERSA.
| Code: |
| AND B.CODE = DECODE( B.REQTNO, 'ABC', 'X', 'Y' ) |
|
|
