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
Sudhan,
The below link contains the info you’re looking for:
https://code.kx.com/trac/wiki/QforMortals2/queries_q_sql#Joins
Regards,
Fintan.