Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL Help Anyone?

Re: SQL Help Anyone?

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 19 Jul 2007 09:49:45 -0700
Message-ID: <1184863785.898354@bubbleator.drizzle.com>


amerar_at_iwc.net wrote:
> Hi,
>
> I'm having a bit of trouble in creating this SQL statement.
> Basically the SQL statement select records from a customer order
> table. That part is simple enough.
>
> However, customers that created an order on a certain day and
> cancelled the order on that same day, I want to exclude those records.
>
> So, am I joining the table to itself? I'm a bit lost on how to do
> this through SQL, without writing a program to do it..........

No version
No DDL
Not even an attempt at DML
No help is possible

Find someone in your organization qualified to do your work and ask them to teach you.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Jul 19 2007 - 11:49:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US