IF-else inSQL

[Guest_imported]

hi,
i am a novice SQL user. i have a problem for which i need to use if else statement. Can i use it in SQL.
the example:

if main_class="M"
select a, b, c
from z
where mt_policy=z.aci_doc_no1(i have to use this if doc_type=p)
where cc_policy=z.aci_doc_no1(i have to use this if doc_type=b)

if main_class<>&quot;M&quot;
select s, a, m
from z
where mt_policy=z.aci_doc_no1(i have to use this if doc_type=p)
where cc_policy=z.aci_doc_no1(i have to use this if doc_type=b)

 

[tlbroadbent]

Use a combination of AND and OR in the where clause.

Example:
if main_class=&quot;M&quot;
Select a, b, c
From z
Where (doc_type='p' And mt_policy=z.aci_doc_no1)
Or (doc_type='b' And cc_policy=z.aci_doc_no1)
Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains &quot;Suggestions for Getting Quick and Appropriate Answers&quot; to your questions.