littleIdiot
MIS
Hi,
I'm sure this is easy to do - but I'm still building my knowledge as I work so turning to trusty tek-tips forums for help ...
Table 1: SEIS_DISCRIPTION
Table 2: DATACARRIER
I am trying to find all unique BARCODE and DATACARRIER values from DATACARRIER where LINE = U3* in SEIS_DISCRIPTION.
I know that te IDX value is the key - jsut not how to link the results!
Simple eh?
All help appreciated,
littleIdiot.
PS Spelling of "DISCRIPTION" is intentionally incorrect!
I'm sure this is easy to do - but I'm still building my knowledge as I work so turning to trusty tek-tips forums for help ...
Table 1: SEIS_DISCRIPTION
Code:
SEIS_DISCRIPTION Null? Type
------------------------------- ----
IDX NUMBER
FORMAT VARCHAR2(6)
START_CDP NUMBER
END_CDP NUMBER
FIRST_RECORD NUMBER
LAST_RECORD NUMBER
SAMPLES NUMBER
SAMP_RT NUMBER
LOGICAL_REEL_NUM NUMBER
CHANNELS NUMBER
RECORD_LENGTH NUMBER
JOB_ID NUMBER
FIRST_X_COORD NUMBER
LAST_X_COORD NUMBER
FIRST_Y_COORD NUMBER
LAST_Y_COORD NUMBER
LINE VARCHAR2(16)
Table 2: DATACARRIER
Code:
DATACARRIER Null? Type
------------------------------- ----
IDX NUMBER
BARCODE VARCHAR2(12)
PROJECT VARCHAR2(20)
REEL_NUM VARCHAR2(12)
LOCATION NUMBER
CREATION_DATE DATE
FIRST_LINE VARCHAR2(16)
DENSITY VARCHAR2(1)
KINDCODE VARCHAR2(6)
KINDDIS NUMBER
ARCHIVE_NAME VARCHAR2(16)
QC_STATUS VARCHAR2(5)
I am trying to find all unique BARCODE and DATACARRIER values from DATACARRIER where LINE = U3* in SEIS_DISCRIPTION.
I know that te IDX value is the key - jsut not how to link the results!
Simple eh?
All help appreciated,
littleIdiot.
PS Spelling of "DISCRIPTION" is intentionally incorrect!