Re: SQL query

vani wrote:

> Hi Guys,
> I want to do a SQL query instead of PL/SQL ,can anyone help me in doing
> this.
> Here is the problem.
>
> To get items that match the following conditions
>
> 1. Select items that have a history of receipts for the past 6 months
>
> 2. Select the recent 10 receipts for those items
>
> 3. Do not select those items that have a reject status even in one of
> the selected 10 receipts
>
> Thanks.

Oacle version?
DDL for tables and primary keys?
Some effort demonstrating you tried to do this yourself first?

I suspect this isn't homework but the odor is definitely there.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)