<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>
<pre id="sql_output" style="margin-top: 0px; margin-bottom: 0px; padding: 0px; line-height: 12px; background-color: rgb(255, 255, 255);">I need to make report to extract serials data </pre><pre id="sql_output" style="margin-top: 0px; margin-bottom: 0px; padding: 0px; line-height: 12px; background-color: rgb(255, 255, 255);">but its not working</pre><pre id="sql_output" style="margin-top: 0px; margin-bottom: 0px; padding: 0px; line-height: 12px; background-color: rgb(255, 255, 255);">i think there is sothing wrong but i don't konow</pre><pre id="sql_output" style="margin-top: 0px; margin-bottom: 0px; padding: 0px; line-height: 12px; background-color: rgb(255, 255, 255);">could any body help me</pre><pre id="sql_output" style="margin-top: 0px; margin-bottom: 0px; padding: 0px; line-height: 12px; background-color: rgb(255, 255, 255);"><br></pre><pre id="sql_output" style="margin-top: 0px; margin-bottom: 0px; padding: 0px; line-height: 12px; background-color: rgb(255, 255, 255);"><br></pre><pre id="sql_output" style="margin-top: 0px; margin-bottom: 0px; padding: 0px; line-height: 12px; background-color: rgb(255, 255, 255);">select
ExtractValue(marcxml,'//datafield[@tag="501"]/subfield[@code>="a"]') as ID,
ExtractValue(marcxml,'//datafield[@tag="310"]/subfield[@code>="a"]') as Freq,
ExtractValue(marcxml,'//datafield[@tag="245"]/subfield[@code>="a"]') as Title,
ExtractValue(marcxml,'//datafield[@tag="260"]/subfield[@code>="b"]') as Publisher,
ExtractValue(marcxml,'//datafield[@tag="260"]/subfield[@code>="a"]') as Publication place,
ExtractValue(marcxml,'//datafield[@tag="546"]/subfield[@code>="a"]') as Language,
ExtractValue(marcxml,'//datafield[@tag="500"]/subfield[@code>="a"]') as Note,
ExtractValue(marcxml,'//datafield[@tag="500"]/subfield[@code>="a"]') as Subject,
ExtractValue(marcxml,'//datafield[@tag="982"]/subfield[@code>="a"]') as Price,
from
biblioitems
where
itemtype = CR</pre><br><p align="center"><font style="" face="Lucida Handwriting, Cursive"><strong><br></strong></font></p><p align="center"><font style="" face="Lucida Handwriting, Cursive"><strong><br></strong></font></p><p align="left"><font face="Lucida Handwriting, Cursive"><strong>Mohamed El Zalabany</strong></font></p><div align="left"><strong></strong></div><div align="center"><div align="left"><strong>Integrated library systems consultant</strong><br><br>Zalabany Knowledge Systems Team©<br>For Libraries and Information systems Development and support<br>mh_zalabany@hotmail.com<br>Mobile: 0009989496<br><br></div><strong></strong></div> </div></body>
</html>