SELECT d."COMPARISON_ID",d."SCAN_ID",d."LOC_ROWID",d."RMT_ROWID",d."IDX_VAL",d."STATUS",d."LAST_UPDATE_TIME",d."SPARE1",d."SPARE2",d."SPARE3",d."SPARE4" FROM comparison_row_dif$ d, comparison$ c
WHERE d.comparison_id = c.comparison_id
AND user# = uid
SELECT D."COMPARISON_ID"
, D."SCAN_ID"
, D."LOC_ROWID"
, D."RMT_ROWID"
, D."IDX_VAL"
, D."STATUS"
, D."LAST_UPDATE_TIME"
, D."SPARE1"
, D."SPARE2"
, D."SPARE3"
, D."SPARE4"
FROM COMPARISON_ROW_DIF$ D
, COMPARISON$ C
WHERE D.COMPARISON_ID = C.COMPARISON_ID
AND USER# = UID
|
|
|