tps://webmail.rcmusic.ca/owa/redir.aspx?C=b481823b299d45ee94b0016389bb76e9&URL=http%3a%2f%2fwww.rcmusic.ca%2f>
From: Barton Chittenden [bar...@bywatersolutions.com]
Sent: Saturday, March 26, 2016 2:49 PM
To: Craig Butosi
Cc: koha
Subject: Re: [Koha] SQL Query - It
I think this should do what you want.
SELECT
biblionumber,
itemcallnumber
FROM
biblioimages
LEFT JOIN items using (biblionumber)
WHERE
imagefile IS NOT NULL
On Mar 26, 2016 1:51 PM, "Craig Butosi" wrote:
> Sorry, sent prematurely:
>
> The error is :
>
> The following error wa
Sorry, sent prematurely:
The error is :
The following error was encountered:
The database returned the following error:
Column 'biblionumber' in field list is ambiguous
Please check the log for further details.
Any suggestions?
Many thanks,
Craig Butosi, MA, MLIS, B Mus (Hons.)
LIBRARY SERVICE
Hi all,
Koha 3.22 on Ubuntu 14.04 LTS (package install)
I`m trying to write a basic SQL query to pull all items with a local cover
image. I`m running Coce now, so I no longer need to upload local cover images
to Koha. I need to identify these records so I can remove their images. I have
a basi
4 matches
Mail list logo