[Koha] SQL report: help needed

[Vimal Kumar]

Dear Friends,

I have created an SQL query to create a collection list for our library.
This report will display the details like Call Number, author, title etc.
I could not include the element for subject or keyword.
Here, I am using 650-a field for keyword in cataloguing.
I could not found the details of  table and field of "keyword" (650-a
Topical term) in Koha.

Can you help me to complete this SQL query for this report?

SELECT
items.itemcallnumber,biblio.author,biblio.title,biblio.copyrightdate,biblioitems.publishercode,biblioitems.place
FROM items LEFT JOIN biblioitems on
(items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on
(biblioitems.biblionumber=biblio.biblionumber)  ORDER BY
items.itemcallnumber asc

Regards,

-- 
Vimal Kumar V.
Asst. Librarian
Asian School of Business
Technopark, Trivandrum-695 581
Web: www.vimalkumar.co.nr
Blog: http://vimalkumar.oksociety.in

OK Society Volunteer. http://oksociety.in
---------------------------------------------------------------------------
"I forget what I was taught. I only remember what I have learnt"
-Patrick White
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20100408/dff15e74/attachment.htm