[Koha] Catalogue - SQL Report Help

[Indranil Das Gupta]

Hello,

On Sat, Jan 24, 2015 at 1:17 PM, SATISH <lis4satish at gmail.com> wrote:

> can you please help me how to alter this code, so that , It could fetch
> only non-repeatable/unique records ( by collection code -or- merging all
> collections codes) only including item types =book and =book bank.

You have answered your own question :) You simply need to insert an
AND to WHERE clause. Google up basic SQL syntax that should get you
going.

-idg

-- 
Indranil Das Gupta

Phone : +91-98300-20971
Blog    : http://indradg.randomink.org/blog
IRC      : indradg on irc://irc.freenode.net
Twitter : indradg

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=-
Please exchange editable Office documents only in ODF Format. No other
format is acceptable. Support Open Standards.

For a free editor supporting ODF, please visit LibreOffice -
http://www.documentfoundation.org