View | Details | Raw Unified | Return to bug 17578
Collapse All | Expand All

(-)a/C4/Members.pm (-3 lines)
Lines 150-156 sub GetMemberDetails { Link Here
150
            SELECT borrowers.*,
150
            SELECT borrowers.*,
151
                   category_type,
151
                   category_type,
152
                   categories.description,
152
                   categories.description,
153
                   enrolmentperiod
154
            FROM borrowers
153
            FROM borrowers
155
            LEFT JOIN categories ON borrowers.categorycode=categories.categorycode
154
            LEFT JOIN categories ON borrowers.categorycode=categories.categorycode
156
            WHERE borrowernumber = ?
155
            WHERE borrowernumber = ?
Lines 162-168 sub GetMemberDetails { Link Here
162
            SELECT borrowers.*,
161
            SELECT borrowers.*,
163
                   category_type,
162
                   category_type,
164
                   categories.description,
163
                   categories.description,
165
                   enrolmentperiod
166
            FROM borrowers
164
            FROM borrowers
167
            LEFT JOIN categories ON borrowers.categorycode = categories.categorycode
165
            LEFT JOIN categories ON borrowers.categorycode = categories.categorycode
168
            WHERE cardnumber = ?
166
            WHERE cardnumber = ?
169
- 

Return to bug 17578