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

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