Hello Good Morning. We maintain two item types for books as Books (BK) and Book Bank (BB) just to accommodate circulation rules/policies. Reason, regular students gets only 2 books from regular stock and reserved students get 2 additional books from Book Bank along with regular stock (BK). And am looking for help for generating unique records (biblio) after merging both BK and BB. I am trying with following sql, but throwing errors. Can you please help me over here. ---------------------------------------------------------------------------------------------------------------------------- SELECT DISTINCT b.biblionumber, b.title, b.author, t.editionstatement, t.publishercode, t.isbn, i.ccode, count(i.itemnumber) FROM biblio b LEFT JOIN biblioitems t USING(biblionumber) LEFT JOIN items i USING(biblionumber) WHERE items.itype='BB' AND items.itype='BK' GROUP BY b.biblionumber --------------------------------------------------------------------- Error: The database returned the following error: Unknown column 'items.itype' in 'where clause' I am not sure how to proceed further. With Thanks. Satish MV Librarian Govt. Engineering College, Hassan. Karnataka. India. On Sun, Jan 25, 2015 at 2:14 PM, Indranil Das Gupta <indradg@gmail.com> wrote:
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
--