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) like 'SCRATCH%' and a.library_name='$i'
and a.library_name=b.library_name group by a.library_name,b.devtype"

$i will be filled with the name of the library before. The funny thing, it
shows exactly as twice as many scratches. Is there someone amongst you who
can exctract this little monster for me and show me what I am doing wrong.

Thanks for helping out

Lars