diff options
| author | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2008-02-20 19:38:51 +0000 |
|---|---|---|
| committer | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2008-02-20 19:38:51 +0000 |
| commit | 75adf4fe0965c67e82200deed4e23b873c48f8dd (patch) | |
| tree | 63bab8b288a387301a6a9fc7ecc40e47855aaa49 | |
| parent | 363aabc827c18a389b1fc54f4c4d42bbf5130d61 (diff) | |
Changing batch search to handle null created_by values
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2074 4979c152-3d1c-0410-bac9-87ea11338e46
| -rw-r--r-- | sql/modules/Voucher.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/modules/Voucher.sql b/sql/modules/Voucher.sql index 31de0bae..59c1df6c 100644 --- a/sql/modules/Voucher.sql +++ b/sql/modules/Voucher.sql @@ -170,7 +170,7 @@ BEGIN ) AS payment_total FROM batch b JOIN batch_class c ON (b.batch_class_id = c.id) - JOIN users u ON (u.entity_id = b.created_by) + LEFT JOIN users u ON (u.entity_id = b.created_by) JOIN voucher v ON (v.batch_id = b.id) JOIN batch_class vc ON (v.batch_class = vc.id) LEFT JOIN ar ON (vc.id = 2 AND v.trans_id = ar.id) |