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
: need help with a complicated join
>
>
> In article <[EMAIL PROTECTED]>,
> Harald Fuchs <[EMAIL PROTECTED]> writes:
>
> > SELECT q.symbol, q.date,
> > q.quote * product (s.split_from / s.split_to) AS adjusted_quote
> > FROM quotes q
> > LEFT JO
]Subject: 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 VARCHAR(127)NOT NULL,
dateDATENOT NULL,
quote FL
I've been working on something similar to this for quite a while (few
more steps, maybe), and this list helped me through it, so I suppose I
can at least return the favor.
You basically need to do the following (I'm using temporary tables to
help me think through it - and because of the lack of
I've been browsing through posts here, but I haven't found anything relevant
to my issue, so I guess I'll just post it myself:
I have three tables: users, groups (which define collections of users),
messages, and replies (replies are completely different from messages and
warrant their own table).
