Re: Complex SELECT problem

Dulare wrote:
> Hi.
>
> SELECT article, price, decode(on_stock, 'Y', 'Yes', 'N', 'No')
> WHERE purchase_date BETWEEN %start and end date%
> ORDER BY article
>
> Pawel Dulak

Yes but not with your code. Where did you get the following: WHERE purchase_date BETWEEN %start and end date%?

This should be written as:

WHERE purchase_date BETWEEN start_date AND end_date;

and you need to provide the values of start_date and end_date date variables.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)