I have a large database with splayed tables on disk. I need a way to join these tables for querying and reporting. Since the tables are splayed and partitioned, it is not possible to have primary/foreign keys, so no join is possible. the only alternative is creating linked columns. However, in my case, key is a multi-column. Is it possible to create linked columns for multi-columns? For example:
t1:(a:1 2 3;b:ab`c;c:10 20 30);
t2:(a2:1 2;b2:ab;c2:100 200);
I want to create a column in t2 that links t2[a2b2] to t1[ab]. This doesn’t work:
select t1link:t1!t1[a`b]?(a2;b2) from t2