Hello, On Sat, Jan 24, 2015 at 1:17 PM, SATISH <lis4satish@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