zOs/SQL/XB111

select d1.*, d8.*
    from
(select EYPREF || ENSTORAR || ENSEG db, count(*)
    from bua.txbc111
    group by EYPREF || ENSTORAR || ENSEG ) d1
FULL outer join
  ( select t.dbName db, count(*)
        from bua.txbc181 x8
          left outer join sysibm.systables t
          on   XBC181_CREATOR = t.creator
           and XBC181_TABNAME = t.name
        group by t.dbName
  ) d8
  on d1.db = d8.db