ld also improve the scratch query by changing
>
> upper(status) like 'SCRATCH%'
>
> to
>
> status='Scratch'
>
> I hope this helps.
>
> Bill
>
>
> -Original Message-----
> From: Lars Bebensee [mailto:[EMAIL
lto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 5:35 AM
To: [EMAIL PROTECTED]
Subject: Select for Scratches
Hi folks,
I am not that good with select queries yes, so I will have to ask one of the
SQL gurus here: we wanted to show how many scratch tapes each library has
with a query like
this
:35 AM
To: [EMAIL PROTECTED]
Subject: Select for Scratches
Hi folks,
I am not that good with select queries yes, so I will have to ask one of the
SQL gurus here: we wanted to show how many scratch tapes each library has
with a query like
this:
"select a.library_name,count(*) as volumes, b.de
upper(status) like 'SCRATCH%'
to
status='Scratch'
I hope this helps.
Bill
-Original Message-
From: Lars Bebensee [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 5:35 AM
To: [EMAIL PROTECTED]
Subject: Select for Scrat
Hi folks,
I am not that good with select queries yes, so I will have to ask one of
the SQL gurus here:
we wanted to show how many scratch tapes each library has with a query like
this:
"select a.library_name,count(*) as volumes, b.devtype from libvolumes as a,
devclasses as b where upper(status)
