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

From: Ken Tough <ken_at_objectech.co.uk>
Date: Mon, 10 May 1999 13:19:42 +0100
Message-ID: <Mxw1A5Ce7sN3Ewv6@objectech.co.uk>

Apparently Mitch <mabaza25_at_usaDELETE.net> 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 - 07:19:42 CDT