cancel
Showing results for 
Search instead for 
Did you mean: 

Keyed table and Joins ...

Sudhan
New Contributor
I am trying to load fixed width data from files into tables and jointwo such tables.I have successfully loaded the fixed width data. It seems I need tounderstand the following before I make further progress:1- Do the PK cols always need to be in the front (beginning set ofcols)?2- After hacking the load to have PKs in the front, when I try to joinusing t1, t2 I get > 'mismatch < ; I have verified the cols are in thesame order in both tables and they are of same type (symbols)3- Can't I just join two 'non-keyed' tables on arbitrary cols?Can someone enlighten me? Thanks in advance
1 REPLY 1

f_
New Contributor
Sudhan,
 
The below link contains the info you're looking for:
 
 
Regards,
 
Fintan.