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

Home -> Community -> Usenet -> c.d.o.tools -> Re: SQL help

Re: SQL help

From: John Grogan <john.grogan_at_southlanarkshire.gov.uk>
Date: Fri, 19 Jan 2001 14:00:21 GMT
Message-ID: <949h9g$cd6$1@nnrp1.deja.com>

See also Matthew Fuller's reply to your post - missed that bit!

--
John Grogan

Hamilton, Scotland, UK

In article <949h5l$c37$1_at_nnrp1.deja.com>,
  John Grogan <john.grogan_at_southlanarkshire.gov.uk> wrote:

> Have you tried "parenthesising" (if that's a word!), the two
conditions
> before and after the "or"? e.g.
>
> (AND
> (b.bt_iw_date BETWEEN TO_DATE ('&start_date', 'DD/MM/YYYY')
> AND TO_DATE ('&end_date', 'DD/MM/YYYY'))
> OR
> (b.bt_entry_date BETWEEN TO_DATE ('&start_date', 'DD/MM/YYYY')
> AND TO_DATE ('&end_date', 'DD/MM/YYYY'))
> )
>
> --
> John Grogan
>
> Hamilton, Scotland, UK
> In article <949gk7$bj4$1_at_nnrp1.deja.com>,
> jwaterh_at_my-deja.com wrote:
> > Sorry if this is a re-post
> >
> > Could someone please offer me some help. i am trying to write a
script,
> > of which I am about 90% of the way there. Basically, the date poeple
> > enter data is stored in either one of either two columns (depends on
> > how that data was entered into the system). The script I am writting
> > pulls out a report based upon whether either b.bt_iw_date or
> > b.bt_entry_date falls within the entered range , which is no problem
> > when I have to deal with just one column. This is what I have
written
> > so far (the important bits anyway):
> >
> > ACCEPT start_date DATE FORMAT 'DD/MM/YYYY' -
> > PROMPT 'Please enter the start date of this report ("DD/MM/YYYY"): '
> >
> > ACCEPT end_date DATE FORMAT 'DD/MM/YYYY' -
> > PROMPT 'Please enter the end date of this report ("DD/MM/YYYY"): '
> >
> > SELECT TO_CHAR (sysdate, 'DD/MM/YYYY') TODAY,
> > b.bt_authorised_by "POSTED BY", b.bt_ref "BATCH
> > NUMBER",b.bt_entry_date "DATE", b.bt_iw_date "DATE", (count
(distinct
> > i.il_po_no)) "INVOICES" , (count (i.il_po_no)) "LINES"
> > FROM batches b, invoice_lines i
> > WHERE b.bt_ref = i.il_batch_ref
> > AND b.bt_sub_ledger = 'SL1'
> > (AND b.bt_iw_date BETWEEN TO_DATE ('&start_date', 'DD/MM/YYYY')
> > AND TO_DATE ('&end_date', 'DD/MM/YYYY')
> > OR b.bt_entry_date BETWEEN TO_DATE ('&start_date', 'DD/MM/YYYY')
> > AND TO_DATE ('&end_date', 'DD/MM/YYYY'))
> > GROUP BY b.bt_authorised_by, b.bt_ref, b.bt_iw_date,b.bt_entry_date,
> > i.il_po_no
> > /
> >
> > Which does not work because of the 'OR' bit. I am sure a solution is
> > staring me in the face, but I can not find it.
> >
> > Thanks for your time.
> >
> > Regards
> >
> > Sent via Deja.com
> > http://www.deja.com/
> >
>
> Sent via Deja.com
> http://www.deja.com/
>
Sent via Deja.com http://www.deja.com/
Received on Fri Jan 19 2001 - 08:00:21 CST

Original text of this message

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