[Koha] SQL report 650 a

[Holger Meissner]

yoonus para wrote:
> Dear all,
>
> How to create a SQL report using field 650 a with barcode and title,Please help me to create this report.
>
> Thanks
> Yoonus

Did you find a solution? I thought it might be interesting, but I also can't figure it out.

When I run
SELECT * FROM marc_subfield_structure WHERE tagfield = 650 AND tagsubfield = 'a'

it tells me the "kohafield" is bibliosubject.subject, yet it seems that I don't have a table called bibliosubject. Is that normal?