metasql/registrar.invoices.sql

diff --git a/metasql/registrar.invoices.sql b/metasql/registrar.invoices.sql
index c5d6cef..399dde5 100644 (file)
--- a/metasql/registrar.invoices.sql
+++ b/metasql/registrar.invoices.sql
@@ -90,11 +90,11 @@ FROM
     LEFT JOIN
             cntct AS admin_cntct
     ON
-            admin_cntct.id = invchead_registrar_admin_cntct_id
+            admin_cntct.cntct_id = invchead_registrar_admin_cntct_id
     LEFT JOIN
             addr AS admin_cntct_addr
     ON
-            admin_cntct_addr.id = admin_cntct.cntct_addr_id
+            admin_cntct_addr.addr_id = admin_cntct.cntct_addr_id
     WHERE
         (
                 (TRUE)