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

From: Ken Tough <>
Date: Mon, 10 May 1999 13:19:42 +0100
Message-ID: <>

Apparently Mitch <> wrote:

>"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"

then Table1.Price, Table2.Date ... what?

can you not formulate it with two queries instead, and just catenate the two sets of results?

Ken Tough
Received on Mon May 10 1999 - 14:19:42 CEST

Original text of this message