0401... .... | ... 21 .... 4323432 ... FFFF00452342334FFFFFF23333333333233333 #### Create table FILE1 as Select column1, column2, column4, column5 From CSPAM Where TNDR_VOID_C = '0' AND OCCUR_Q > 1 Create table FILE2 as Select column1, column3, column14, column25 From ACCT Where ST = 'MN' Select a.*, b* from FILE1 a, FILE2 b where a.ID = b.ID