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 (
: [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) als
.net>cc:
Sent by: newsFax to:
<[EMAIL PROTECTED]Subject: Re: need help with a
complicated join
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
Sent by: "Fyodor cc:
Golos" Fax to:
<[EMAIL PROTECTED
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 VARCHAR(127)NOT NULL,
dateDATENOT NULL,
quote FL
