[Koha-bugs] [Bug 6271] GetItemIssue(s) : renewals in both items and issues tables

[bugzilla-daemon at bugs.koha-community.org]

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

--- Comment #2 from Fridolyn SOMERS <fridolyn.somers at gmail.com> 2011-04-27 13:59:00 UTC ---
(In reply to comment #1)
> SELECT * is generally frowned on in db circles and issues.renewals and
> items.renewals describe the contents of these fields accurately. If one changes
> name theres not really a good way of recalling which one has been aliased (or
> why if dealing only with that table)

I agree,
the LEFT JOIN is only to get some fields from items.
We should change 
SELECT * in :

-- 
Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA Contact for the bug.