<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">Greetings,<br><br>I'm Yared from Ethiopia, Hawassa University. I had a problem on MARC a couple of days and it was solved successfully. Now we were trying to install and us Koha 3.0.02 version on Ubuntu 8.04 LTS version for the University library information System. after a while when want to generate a guided report using the following sql statement it won't display the copynumber.<br>the sql statement is as follow.<br><br><div style="margin-left: 40px;"><span style="font-style: italic;">select b.title, itemcallnumber, barcode, copynumber, i.timestamp from biblio b, items i where b.biblionumber = i.biblionumber and homebranch ="TLIB" and i.timestamp > "2009-10-02 14:32:17" </span><br><br></div>But the copynumber does exist and is views with the catalogue view when we execute cgi-bin/koha/catalogue/MARCdetail.pl file. <br><br>please help
me,<br><br></td></tr></table><br>