select BCT.COLOR_SET_ID, BCT.COLOR_METHOD_ID, BCT.COLOR_LEVEL1, BCT.COLOR_LEVEL2, BCT.COLOR_LEVEL3, BCT.COLOR_LEVEL4, BCS.NAME
from BIS_COLOR_TRIGGERS_B BCT, BIS_COLOR_TRIGGERS_SET_TL BCS
where BCT.COLOR_SET_ID = BCS.COLOR_SET_ID
SELECT BCT.COLOR_SET_ID
, BCT.COLOR_METHOD_ID
, BCT.COLOR_LEVEL1
, BCT.COLOR_LEVEL2
, BCT.COLOR_LEVEL3
, BCT.COLOR_LEVEL4
, BCS.NAME
FROM BIS_COLOR_TRIGGERS_B BCT
, BIS_COLOR_TRIGGERS_SET_TL BCS
WHERE BCT.COLOR_SET_ID = BCS.COLOR_SET_ID
|
|
|