No need for dummy table when we don't use select *

diff --git a/enyo-client/database/source/xm/javascript/item_site.sql b/enyo-client/database/source/xm/javascript/item_site.sql
index 298bd21..5ddbacd 100644 (file)
--- a/enyo-client/database/source/xm/javascript/item_site.sql
+++ b/enyo-client/database/source/xm/javascript/item_site.sql
@@ -77,10 +77,6 @@ select xt.install_js('XM','ItemSite','xtuple', $$
              'from ( ' +
              'select t1.%3$I as id {groupColumns} ' +
              'from %1$I.%2$I t1 {joins} ' +
-             /* Add dummy/blank itemalias join to satisfy unions below. */
-             'left join (' +
-             '  select * from itemalias where true = false ' +
-             ') as itemalias on t1.%4$I=itemalias_item_id ' +
              'where {conditions} {extra}',
       sql2 = 'select * from %1$I.%2$I where id in ({ids}) {orderBy}';