[Koha-bugs] [Bug 6303] Display Organisation and Parent Organisation names when viewing a borrower of type organisation

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Thu Nov 24 11:40:33 CET 2011


http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6303

Paul Poulain <paul.poulain at biblibre.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Version|master                      |rel_3_8
       Patch Status|Passed QA                   |Patch Pushed

--- Comment #22 from Paul Poulain <paul.poulain at biblibre.com> 2011-11-24 10:40:33 UTC ---
Small comment: in SQL,
LEFT JOIN categories ON borrowers.categorycode=categories.categorycode
can also be written
LEFT JOIN categories USING(categorycode)

when both fields have the same name and there can't be any ambiguity on the
tables applicable (there can be some when multiple LEFT JOIN). I personnally
prefer this syntax, that hilight more the field you join on.

Patch pushed, please test

-- 
Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are watching all bug changes.


More information about the Koha-bugs mailing list