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 <[email protected]> > 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 AS vendor > FROM aqorders o > Order by v.name ASC > > Hope that helps, > > James Ghiorzi > Library Assistant II > San Benito County Free Library > 470 Fifth ST. > Hollister, CA 95023 > > > > ------------------------------ > *From:* [email protected] [[email protected]] > On Behalf Of Massimo Plevani [[email protected]] > *Sent:* Monday, November 07, 2011 8:19 AM > *To:* [email protected] > *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 > [email protected] > http://lists.katipo.co.nz/mailman/listinfo/koha > >
_______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
