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