Hi Nicole, Thanks for the correction :) Respectfully, James Ghiorzi Library Assistant II San Benito County Free Library 470 Fifth St. Hollister, CA 95023 (831) 636-4107 ________________________________ From: Nicole Engard [nengard@gmail.com] Sent: Monday, November 07, 2011 9:52 AM To: James Ghiorzi Cc: Massimo Plevani; koha@lists.katipo.co.nz Subject: Re: [Koha] Acquisition module James, That won't do the trick - but this will: SELECT name from aqbooksellers order by name asc And you're right about not being able to delete. Nicole 2011/11/7 James Ghiorzi <JGhiorzi@lib.co.san-benito.ca.us<mailto:JGhiorzi@lib.co.san-benito.ca.us>> Hi Massimo, 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't know how to do it). The list of vendors here is my amateurish stab at it: SELECT v.name<http://v.name> AS vendor FROM aqorders o Order by v.name<http://v.name> ASC Hope that helps, James Ghiorzi Library Assistant II San Benito County Free Library 470 Fifth ST. Hollister, CA 95023 ________________________________ From: koha-bounces@lists.katipo.co.nz<mailto:koha-bounces@lists.katipo.co.nz> [koha-bounces@lists.katipo.co.nz<mailto:koha-bounces@lists.katipo.co.nz>] On Behalf Of Massimo Plevani [max_pleva@hotmail.it<mailto:max_pleva@hotmail.it>] Sent: Monday, November 07, 2011 8:19 AM To: koha@lists.katipo.co.nz<mailto:koha@lists.katipo.co.nz> Subject: [Koha] Acquisition module Dear all, I started to work with acquisition module. I have some questions: 1. How can I delete a vendors? 2. Can I see the list of vendors (e.g Alphabeticaly ordered)? Thanks you for your help. All the best. Massimo Plevani _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz<mailto:Koha@lists.katipo.co.nz> http://lists.katipo.co.nz/mailman/listinfo/koha