Re: How to do a difference on two sets from same table?
Date: Tue, 31 Aug 2004 03:26:54 GMT
Message-ID: <2eSYc.10965$Tq.9705_at_trndny02>
You must learn how to use MINUS. It is as important as joins.
"Dan" <dan_at_nospam.com> wrote in message
news:uNIYc.27$5p3.18307_at_news.uswest.net...
> I don't know what you mean. Could someone give me the complete SQL?
>
> TIA,
> Dan
>
> On 8/30/2004 2:55 AM, pstnotpd wrote:
> > Have a look at MINUS
> >
> >
> > Dan wrote:
> >
> >> Hi,
> >>
> >> Say I have a sales history table that has the following fields:
> >> custid, invoicedate, prodid, quantity, cost, sale. And that I want to
> >> select sales records where invoicedate is between 5/1/04 and 8/31/04
> >> and where these are new sales for each customer, meaning that the
> >> customer did not buy the prodid in the period 1/1/04 to 4/30/04. I
> >> know conceptually that this is a difference between two sets based on
> >> custid+prodid but I don't know how to express this in SQL. Please
help.
> >>
> >> TIA,
> >> Dan
Received on Tue Aug 31 2004 - 05:26:54 CEST