[Koha] sql Query solved!

[Martin House]

I posted a question that I think has not been posted to the list yet, as it
is awaiting moderator approval. That said, in case it is posted, I wanted
to share my solution.

Question: How to list all students and their matching teachers?
Problem: Table(borrowers) has patron info, Table(borrower_attribute) has
teacher name and column code "Teacher."

I solved the problem by using mysqlWorkbench and running the following sql
query:

SELECT *
FROM `koha_library`.`borrower_attributes`, `koha_library`.`borrowers`
WHERE `borrowers`.`borrowernumber`= `borrower_attributes`.`borrowernumber`



Martin House
martin.house at gmail.com
www.martindhouse.com
704-996-0297
"An unexamined life is not worth living."