View previous topic :: View next topic
|
Author |
Message |
sivatechdrive
Active User
Joined: 17 Oct 2004 Posts: 191 Location: hyderabad
|
|
|
|
Hi
can we use the if condition or any other condition in select query
ie i use to select query for two conditons
If flag = not set
Select * from Table
where role_plyr_id = 'xxxxx'
and valid_from_date = '01/01/2004'
If flag = set
Select * from Table
where role_plyr_id = 'xxxxx'
and valid_from_date = '01/01/2004'
and Agreement_id = 'oooo'
plz find that only one line is in where condition difers between 2 queries
can we the query like below
Select * from Table
where role_plyr_id = 'xxxxx'
and valid_from_date = '01/01/2004'
if Flag = set
Agreement_id = 'oooo'
else
continue
End-if
Thanks
Siva |
|
Back to top |
|
|
janardhana Reddy
New User
Joined: 20 Oct 2004 Posts: 17 Location: Bangalore
|
|
|
|
Hi ,
It's not possible to use the if condition in the query, but after fetching the result from the first query you can check the value of column Agreement_id and proceed further..
thanks
Janardhan |
|
Back to top |
|
|
|