No subject

>From chris at katipo.co.nz Thu May  5 06:42:40 2005
Return-Path: <chris at katipo.co.nz>
Delivered-To: chris at wilbur.katipo.co.nz
Received: (qmail 12275 invoked from network); 4 May 2005 18:42:40 -0000
Received: from unknown (HELO shelob.katipo.co.nz) (202.50.109.222)
  by wilbur.katipo.co.nz with SMTP; 4 May 2005 18:42:40 -0000
Received: by shelob.katipo.co.nz (Postfix, from userid 1001)
	id 06C0F848AD; Thu,  5 May 2005 06:42:38 +1200 (NZST)
X-Original-To: chris at katipo.co.nz
Delivered-To: chris at katipo.co.nz
Received: from localhost (localhost [127.0.0.1])
	by shelob.katipo.co.nz (Postfix) with ESMTP id 67B618476B;
	Thu,  5 May 2005 06:42:33 +1200 (NZST)
Received: from shelob.katipo.co.nz ([127.0.0.1])
	by localhost (staff.katipo.co.nz [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id 07797-05; Thu, 5 May 2005 06:42:33 +1200 (NZST)
Received: from daddy-mx.katipo.co.nz (daddy.katipo.co.nz [202.50.109.200])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(No client certificate requested)
	by shelob.katipo.co.nz (Postfix) with ESMTP;
	Thu,  5 May 2005 06:42:33 +1200 (NZST)
Received: from localhost (localhost.katipo.co.nz [127.0.0.1])
	by daddy-mx.katipo.co.nz (Postfix) with ESMTP id 574D8E6F08;
	Thu,  5 May 2005 06:40:08 +1200 (NZST)
Received: from daddy-mx.katipo.co.nz ([127.0.0.1])
	by localhost (daddy.katipo.co.nz [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id 15819-05; Thu, 5 May 2005 06:40:06 +1200 (NZST)
Received: from localhost.katipo.co.nz (localhost.katipo.co.nz [127.0.0.1])
	by daddy-mx.katipo.co.nz (Postfix) with ESMTP;
	Thu,  5 May 2005 06:40:06 +1200 (NZST)
Received: from localhost (localhost.katipo.co.nz [127.0.0.1])
	by daddy-mx.katipo.co.nz (Postfix) with ESMTP id 8B45AE6E8D
	for <Koha at lists.katipo.co.nz>; Thu,  5 May 2005 06:40:01 +1200 (NZST)
Received: from daddy-mx.katipo.co.nz ([127.0.0.1])
	by localhost (daddy.katipo.co.nz [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id 18409-04 for <Koha at lists.katipo.co.nz>;
	Thu, 5 May 2005 06:40:00 +1200 (NZST)
Received: from wlpl.org (mail.wlpl.org [204.95.8.76])
	by daddy-mx.katipo.co.nz (Postfix) with ESMTP
	for <Koha at lists.katipo.co.nz>; Thu,  5 May 2005 06:40:00 +1200 (NZST)
Received: from [192.168.1.152] (helo=[192.168.1.152])
	by wlpl.org with esmtp (Exim 2.12 #1) id 1DTOmp-0007Hw-00
	for Koha at lists.katipo.co.nz; Wed, 4 May 2005 13:39:55 -0500
Received: from 127.0.0.1 (AVG SMTP 7.0.308 [266.11.3]);
	Wed, 04 May 2005 13:42:15 -0500
Message-ID: <42791787.7050003 at wlpl.org>
Date: Wed, 04 May 2005 13:42:15 -0500
From: Tim McMahon - West Liberty Public Library <tmcmahon at wlpl.org>
User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Koha at lists.katipo.co.nz
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at katipo.co.nz
Subject: [Koha] Help converting item status from Sagebrush Athena
X-BeenThere: koha at lists.katipo.co.nz
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Discussion list for the Koha Library system <koha.lists.katipo.co.nz>
List-Unsubscribe: <http://lists.katipo.co.nz/mailman/listinfo/koha>,
	<mailto:koha-request at lists.katipo.co.nz?subject=unsubscribe>
List-Archive: <http://lists.katipo.co.nz/pipermail/koha>
List-Post: <mailto:koha at lists.katipo.co.nz>
List-Help: <mailto:koha-request at lists.katipo.co.nz?subject=help>
List-Subscribe: <http://lists.katipo.co.nz/mailman/listinfo/koha>,
	<mailto:koha-request at lists.katipo.co.nz?subject=subscribe>
Sender: koha-bounces at lists.katipo.co.nz
Errors-To: koha-bounces at lists.katipo.co.nz
X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at katipo.co.nz
X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at katipo.co.nz
X-Spam-Checker-Version: SpamAssassin 3.0.2 (2004-11-16)  on 
	shelob.katipo.co.nz
X-Spam-Level: 
X-Spam-Status: No, hits=-2.6 required=5.0tests=BAYES_00 autolearn=ham 
	version=3.0.2
Status: RO
Content-Length: 656

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