Page History

select '\\' || ta.c_table_cd || ont.c_fullname as key,
       '\\' || ta.c_table_cd || ont.c_fullname as local_key
  from ONT_TABLE1 ont
  join table_access ta on substr(ont.c_fullname,1,length(ta.c_fullname)) = ta.c_fullname
  where ont.c_visualattributes not in ('FH','FI','LH','LI')
  UNION
  select '\\' || ta.c_table_cd || ont.c_fullname as key,
       '\\' || ta.c_table_cd || ont.c_fullname as local_key
  from ONT_TABLE2 ont
  join table_access ta on substr(ont.c_fullname,1,length(ta.c_fullname)) = ta.c_fullname
  where ont.c_visualattributes not in ('FH','FI','LH','LI')
  UNION
  select '\\' || ta.c_table_cd || ont.c_fullname as key,
       '\\' || ta.c_table_cd || ont.c_fullname as local_key
  from ONT_TABLE3 ont
  join table_access ta on substr(ont.c_fullname,1,length(ta.c_fullname)) = ta.c_fullname
  where ont.c_visualattributes not in ('FH','FI','LH','LI')