Re: Can you use "If..Then" logic in SQL?

You can either use decode (as suggested) or you can build a PL/SQL or JAVA function which is stored in the DB then you can acess the function like any other column.

--
Paul Dorsey
Dulcian, Inc.
www.dulcian.com
212 595 7223
simone wrote in message <7gmrnj$r0g$1_at_hermes.iol.it>...


>In the SQL statement doesn't exist IF..then, but you can use

>iif(condition;right result; wrong result)

>Mitch ha scritto nel messaggio <7ganjk$de6$1_at_news.doit.wisc.edu>...


>>

>>

>>-- I am programming a VB app that pulls data from an Oracle 8 database

into


>>Access for further manipulation.  I am trying to figure out if there is a

>>way using either Oracle or Jet SQL to use "If..Then" logic in my SQL

query.


>>For example,

>>

>>"Select Table1.*, Table2.* where Table1.Key = Table2.Key (this is where

I'm


>>not sure about the syntax) and If Table2.Price and Table2.Date are NULL

>then

>>Table1.Price, Table1.Date Else Table2.Price and Table2.Date"

>>

>>I am sure I could just pull all records from the Oracle database into

>Access

>>and then use DAO methods to create another recordset that meets the above

>>criteria, but that's bound to be very slow.  I'd like to use strictly SQL

>if

>>possible.  Any and all suggestions (Oracle, Access or VB) are appreciated.

>>

>>Thanks

>>

>>Mitch Abaza

>>mabaza25_at_DELETEusa.net

>>

>>clear "delete" to mail

>>

>>

>>

>

>