SELECT a.ARTICLE_TITLE FOR_NAME, b.ROWID, b.SOURCE_ARTICLE_ID SAE_ID, b.TARGET_ARTICLE_ID SAE_ID_FOR, b.OBJECT_VERSION_NUMBER, b.CREATED_BY, b.CREATION_DATE, b.LAST_UPDATED_BY , b.LAST_UPDATE_DATE , b.LAST_UPDATE_LOGIN FROM OKC_ARTICLE_RELATNS B, OKC_ARTICLES_ALL A WHERE A.article_id=B.source_article_id AND RELATIONSHIP_TYPE ='INCOMPATIBLE'
SELECT A.ARTICLE_TITLE FOR_NAME
, B.ROWID
, B.SOURCE_ARTICLE_ID SAE_ID
, B.TARGET_ARTICLE_ID SAE_ID_FOR
, B.OBJECT_VERSION_NUMBER
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
FROM OKC_ARTICLE_RELATNS B
, OKC_ARTICLES_ALL A
WHERE A.ARTICLE_ID=B.SOURCE_ARTICLE_ID
AND RELATIONSHIP_TYPE ='INCOMPATIBLE'
|
|
|