VIEW: SYS.KU$_CLSTJOIN_VIEW

Source

View Text - Preformatted

select j.clstobj#, j.tab1obj#, j.int1col#, j.tab2obj#, j.int2col#,
            (select value(o) from sys.ku$_schemaobj_view o
             where o.obj_num = j.tab1obj#),
            (select value(o) from sys.ku$_schemaobj_view o
             where o.obj_num = j.tab2obj#),
            (select value(c) from sys.ku$_simple_col_view c
             where c.obj_num = j.tab1obj# and c.intcol_num = j.int1col#),
            (select value(c) from sys.ku$_simple_col_view c
             where c.obj_num = j.tab2obj# and c.intcol_num = j.int2col#)
  from sys.clstjoin$ j
  order by j.tab1obj#, j.int1col#

View Text - HTML Formatted

SELECT J.CLSTOBJ#
, J.TAB1OBJ#
, J.INT1COL#
, J.TAB2OBJ#
, J.INT2COL#
, (SELECT VALUE(O)
FROM SYS.KU$_SCHEMAOBJ_VIEW O
WHERE O.OBJ_NUM = J.TAB1OBJ#)
, (SELECT VALUE(O)
FROM SYS.KU$_SCHEMAOBJ_VIEW O
WHERE O.OBJ_NUM = J.TAB2OBJ#)
, (SELECT VALUE(C)
FROM SYS.KU$_SIMPLE_COL_VIEW C
WHERE C.OBJ_NUM = J.TAB1OBJ#
AND C.INTCOL_NUM = J.INT1COL#)
, (SELECT VALUE(C)
FROM SYS.KU$_SIMPLE_COL_VIEW C
WHERE C.OBJ_NUM = J.TAB2OBJ#
AND C.INTCOL_NUM = J.INT2COL#)
FROM SYS.CLSTJOIN$ J ORDER BY J.TAB1OBJ#
, J.INT1COL#