Home -> Usenet -> comp.databases.oracle -> Using conditional statements inside SQL

Using conditional statements inside SQL

From: Pramod Ramachandran <pramod_at_rtimes.com>
Date: 2 Sep 2002 21:21:36 -0700
Message-ID: <6616e304.0209022021.500f88df_at_posting.google.com> 






Hi all,



I have a problem which is as follows : 



Three tables 



    
  
  1.   TType having a field IVal which can have two groups of values 700
and 750.
  
  2.   Item 
  
  3.   Rule 







I need a query which selects a row from table Item when IVal = 700 and
from Rule when IVal is 750.



I know that this could be achieved with a procedure using an if...else
condition, but I am curious to know if could be solved within a single
query.



TIA


Pramod
Received on Tue Sep 03 2002 - 06:21:36 CEST












Original text of this message