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
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
cc:
Golos Fax to:
[EMAIL PROTECTED]Subject: need help