if else in query

[Pranav Sharma]

i need to write a query which does the following.

  
SELECT table1.*, <A_VARIABLE> 
  FROM table1, table2
  WHERE table1.column="some character" 
        AND ( <A_VARIABLE> = 'Y', if atleast one row exists in table2 with
               table2.column="something"
              [I]else[/I] <A_VARIABLE>='N')
  

Is this possible

[Richard Green]

http://www.devx.com/tips/Tip/15633