metasql/registrar.contracts.sql
authorEdward <edward@roojs.com>
Fri, 19 Dec 2014 09:22:02 +0000 (17:22 +0800)
committerEdward <edward@roojs.com>
Fri, 19 Dec 2014 09:22:02 +0000 (17:22 +0800)
metasql/registrar.contracts.sql

index d58045e..7777974 100644 (file)
@@ -48,7 +48,7 @@ SELECT
             item.item_number,
             CASE WHEN LENGTH(item.item_descrip1) > 0 THEN E'\n' || item.item_descrip1 END
         ) AS product,
-        CASE WHEN aropen.aropen_paid < aropen.aropen_amount
+        CASE WHEN aropen.aropen_paid < aropen.aropen_amount THEN
             'NO'
         ELSE
             'YES'