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 <mtompset@hotmail.com>:
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: koha@lists.katipo.co.nz 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 Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Cordialmente, Humberto Blanco