Hello, On Sat, Jan 24, 2015 at 1:17 PM, SATISH <lis4sat...@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 _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha