man i didnt even know you can do this
AND s.date q.date
i assumed that goes in a where clause ?
-Original Message-
From: news [mailto:[EMAIL PROTECTED] Behalf Of Harald Fuchs
Sent: Wednesday, May 26, 2004 8:01 PM
To: [EMAIL PROTECTED]
Subject: Re: need help with a complicated join
:
Sent by: newsFax to:
[EMAIL PROTECTED]Subject: Re: need help with a
complicated join
rg
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; news
Subject: Re: need help with a complicated join
Harold, you win the EUREKA prize of the month!
I had forgotten all about that silly algebraic trick. This answers another
person's post from last week. (I will try to find it again) also looking
At 14:07 -0500 on 05/25/2004, [EMAIL PROTECTED] wrote about need
help with a complicated join:
I am trying to come up with a query that takes two tables, one with
non-split-adjusted historical stock prices, and one with information on
splits, for instance:
CREATE TABLE quotes (
symbol
You are beyond the realm of SQL. What you would need for something like
this is a dynamically-generated case statement that would apply different
multipliers based on the date of the quote you are trying to adjust. For
those quote values that exist BEFORE multiple splits you must adjust by the