[Koha] How to join aqorders and suggestions

[Humberto Blanco Castillo]

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 at 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 at 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 at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>



-- 
Cordialmente,


Humberto Blanco