[Koha] Help converting item status from Sagebrush Athena

[Tim McMahon - West Liberty Public Library]

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