[Koha] Help converting item status from Sagebrush Athena
Tim McMahon - West Liberty Public Library
tmcmahon at wlpl.org
Thu May 5 06:42:15 NZST 2005
Is there any way to insert or update a column with info from another
table using something like this?
select currcirc.patronid, borrowers.borrowernumber from currcirc,
borrowers where currcirc.patronid=borrowers.cardnumber;
Currcirc is the current circulation from Athena and patronid is their
barcode number. Athena doesn't use anything like the borrowernumber in
Koha, so I need to pull the borrowernumber from the borrowers table to
insert into the issues table. I'll also need to do this for itemnumbers.
_______________________________________________
Koha mailing list
Koha at lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
More information about the Koha
mailing list