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

[Quoted] In the SQL statement doesn't exist IF..then, but you can use iif(condition;right result; wrong result) [Quoted] 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
>
>
>
Received on Tue May 04 1999 - 15:14:32 CEST