SELECT O.OBJECT_ID,F.FACTOR_TYPE FROM FEM_FACTOR_TABLES F,FEM_OBJECT_DEFINITION_VL O WHERE F.object_definition_id = O.object_definition_id and O.object_definition_id = (select min(B.object_definition_id) from fem_object_definition_b B where B.object_id = O.object_id)
SELECT O.OBJECT_ID
, F.FACTOR_TYPE
FROM FEM_FACTOR_TABLES F
, FEM_OBJECT_DEFINITION_VL O
WHERE F.OBJECT_DEFINITION_ID = O.OBJECT_DEFINITION_ID
AND O.OBJECT_DEFINITION_ID = (SELECT MIN(B.OBJECT_DEFINITION_ID)
FROM FEM_OBJECT_DEFINITION_B B
WHERE B.OBJECT_ID = O.OBJECT_ID)
|
|
|