hi, the poblem its here using record fusion for biblio with the same data, then i have the same biblio in many sugestions and orders.
2015-03-11 12:19 GMT-05:00 Mark Tompsett <[email protected]>: > Greetings, > > According to http://schema.koha-community.org/tables/suggestions.html, > there is comment on the biblionumber field: > "foreign key linking the suggestion to the biblio table after the > suggestion has been ordered". > > So, > SELECT * FROM suggestions WHERE biblionumber IS NULL; > is going to list all the suggestions which are NOT ordered. > > I know this isn't the answer you are looking for, but it should help you > find the correct direction. > > GPML, > Mark Tompsett > > -----Original Message----- From: Humberto Blanco Castillo > Sent: Wednesday, March 11, 2015 12:38 PM > To: [email protected] > Subject: [Koha] How to join aqorders and suggestions > > > Hi, > How can i make teh correct relation between aqorders and suggestions? I > need to do a report but is not posible join correctly those tables. > > Any idea??? > > > -- > Cordialmente, > > > Humberto Blanco > _______________________________________________ > Koha mailing list http://koha-community.org > [email protected] > http://lists.katipo.co.nz/mailman/listinfo/koha > -- Cordialmente, Humberto Blanco _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
