Re: Subquery

From: ExecMan <artmerar_at_yahoo.com>
Date: Thu, 20 Oct 2011 08:31:50 -0700 (PDT)
Message-ID: <af6c24df-3f3c-428f-a74d-e88f0c802372_at_h14g2000yqi.googlegroups.com>

On Oct 20, 10:17 am, ExecMan <artme..._at_yahoo.com> wrote:
> Hi,
>
> I've had just about enough of this.  Simple ass query and 3 hours and
> I cannot figure it out.  This will be part of a much large query, but
> here is the basic query and Oracle does not like it.  What is wrong?
>
> SELECT ticker, closing_price
> FROM (SELECT h.ticker,  h.closing_price
>            FROM price_history_mv h
>            WHERE s.m_ticker = h.m_ticker
>               AND TO_DATE(h.price_date,'YYYYMMDD') =
> TRUNC(next_day(sysdate-7,'FRIDAY')))
> FROM stock_info_snapshot s
> WHERE s.z_rank = 1;
>
> >> SQL command not properly ended
>
> Thanks.

Ok, forget that post. Finally for it. dumb thing. Was probably working so fast did not see the syntactical errors. Received on Thu Oct 20 2011 - 10:31:50 CDT