James,<br><br>That won&#39;t do the trick - but this will:<br><br>SELECT name from aqbooksellers order by name asc<br><br>And you&#39;re right about not being able to delete.<br><br>Nicole<br><br><div class="gmail_quote">2011/11/7 James Ghiorzi <span dir="ltr">&lt;<a href="mailto:JGhiorzi@lib.co.san-benito.ca.us">JGhiorzi@lib.co.san-benito.ca.us</a>&gt;</span><br>

<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">





<div>
<div style="font-size:13px;color:#000000;direction:ltr;font-family:Tahoma">
<div><font face="Arial" size="3">Hi Massimo,</font></div>
<div><font face="Arial" size="3"></font> </div>
<div><font face="Arial" size="3">I believe that there is currently no way to delete a vendor using the client interface (there might be a way using SQL, but I wouldn&#39;t know how to do it).</font></div>
<div><font face="Arial" size="3"></font> </div>
<div><font face="Arial" size="3">The list of vendors here is my amateurish<a></a> stab at it:</font></div>
<div><font face="Arial" size="3"></font> </div>
<div>
<pre><span><font face="Arial" size="3">SELECT <a href="http://v.name" target="_blank">v.name</a><a></a><a></a> AS vendor<br>FROM aqorders o <br>Order by <a href="http://v.name" target="_blank">v.name</a> ASC<a></a><a></a></font></span></pre>


<pre><span><font face="Arial" size="3">Hope that helps,</font></span></pre>
<pre><span><font face="Arial" size="3">James Ghiorzi<br>Library Assistant II<br>San Benito County Free Library<br>470 Fifth ST.<br>Hollister, CA 95023</font></span></pre>
<font face="Arial" size="3"> </font></div>
<div dir="ltr"><font color="#000000" face="Arial" size="3"></font> </div>
<div style="direction:ltr"><font face="Arial" size="3">
<hr>
</font><font face="Arial"><font size="3"><font color="#000000"><b>From:</b> <a href="mailto:koha-bounces@lists.katipo.co.nz" target="_blank">koha-bounces@lists.katipo.co.nz</a> [<a href="mailto:koha-bounces@lists.katipo.co.nz" target="_blank">koha-bounces@lists.katipo.co.nz</a>] On Behalf Of Massimo Plevani [<a href="mailto:max_pleva@hotmail.it" target="_blank">max_pleva@hotmail.it</a>]<br>


<b>Sent:</b> Monday, November 07, 2011 8:19 AM<br>
<b>To:</b> <a href="mailto:koha@lists.katipo.co.nz" target="_blank">koha@lists.katipo.co.nz</a><br>
<b>Subject:</b> [Koha] Acquisition module<br>
</font><br>
</font></font></div><div><div></div><div class="h5">
<div><font face="Arial" size="3"></font></div>
<div>
<div dir="ltr"><font face="Arial" size="3">Dear all, </font>
<div><font face="Arial" size="3">I started to work with acquisition module. I have some questions:</font></div>
<div><font face="Arial"><br>
<font size="3"></font></font></div>
<div><font face="Arial" size="3">1. How can I delete a vendors?</font></div>
<div><font face="Arial" size="3">2. Can I see the list of vendors (e.g Alphabeticaly ordered)?</font></div>
<div><font face="Arial"><br>
<font size="3"></font></font></div>
<div><font face="Arial" size="3">Thanks you for your help. All the best.</font></div>
<div><font face="Arial"><br>
<font size="3"></font></font></div>
<div><font face="Arial" size="3">Massimo Plevani</font></div>
</div>
</div>
</div></div></div>
</div>

<br>_______________________________________________<br>
Koha mailing list  <a href="http://koha-community.org" target="_blank">http://koha-community.org</a><br>
<a href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><br>
<a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
<br></blockquote></div><br>