Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Join 2 rows from tables

Hi, i have 2 tables, both has DATAAREAID and JOURNALID. I want to join these 2 rows, how can i do that?     Have i to create a compound key? There are other ways?   Thanks
Need Help
  • itchyeyeballs's avatar
    itchyeyeballs
    7 years ago

    yes, you will have to create a compound key by creating new columns that combine the fields you want to join on.

     

    You could potentially create a seperate lookup table with all the distinct values and corresponding index fields but it's probably only worth it if you have lots of records and/or your compound fields are very long

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Sorry,

i mean thath i want to join 2 table with 2 keys.

 

Have to create a compound key? No other ways?

 

Thanks

itchyeyeballs's avatar
itchyeyeballs
Impactful Individual
7 years ago

yes, you will have to create a compound key by creating new columns that combine the fields you want to join on.

 

You could potentially create a seperate lookup table with all the distinct values and corresponding index fields but it's probably only worth it if you have lots of records and/or your compound fields are very long