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

Paul Poulain <[email protected]> changed:

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

--- Comment #22 from Paul Poulain <[email protected]> 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.
_______________________________________________
Koha-bugs mailing list
[email protected]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to