OK guys, heres the information. Some of the data is packed so it doesnt look like a CSV file or anything like that. Supposely some of the packed information are read vertically rather than horizontally. An example of what the file looks like :
0401... .... | ... 21 .... 4323432 ...
FFFF00452342334FFFFFF23333333333233333
Here is an example of the query, its written in SAS so I changed it to SQL:
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
Thanks again for all your help guys..
Fuism