SF.net SVN: ledger-smb: [867] trunk/sql/upgrade/1.2-1.3.sql

[..hidden..]

Revision: 867
          http://svn.sourceforge.net/ledger-smb/?rev=867&view=rev
Author:   einhverfr
Date:     2007-03-08 11:35:58 -0800 (Thu, 08 Mar 2007)

Log Message:
-----------
Fixing bug in employee search due to use of inner instead of left join

Modified Paths:
--------------
    trunk/sql/upgrade/1.2-1.3.sql

Modified: trunk/sql/upgrade/1.2-1.3.sql
===================================================================
--- trunk/sql/upgrade/1.2-1.3.sql	2007-03-08 19:18:07 UTC (rev 866)
+++ trunk/sql/upgrade/1.2-1.3.sql	2007-03-08 19:35:58 UTC (rev 867)
@@ -151,7 +151,7 @@
 -- as long as we need the datatype, might as well get some other use out of it!
 CREATE OR REPLACE VIEW employee_search AS
 SELECT e.*, m.name AS manager 
-FROM employees e JOIN employees m ON (e.managerid = m.id);
+FROM employees e LEFT JOIN employees m ON (e.managerid = m.id);
 
 CREATE OR REPLACE FUNCTION employee_search
 (in_startdatefrom date, in_startdateto date, in_name varchar, in_notes text,


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.