generic join on splayed and mapped tables on any column

Community Support
1

How do I do a generic join on splayed and mapped tables? In SQL, we can do something like:

select from T1,T2 where T1.c1=T2.c2

The tables are not keyed. An alternative is to create linked columns but it is messy and requires updating. I want to be able to join against any columns. These are fairly large tables. Designating a primary key is not possible as there are potentially repeating entries. I want to be able to get everything in T1 and everything in T2 (and also be able to get first/last entries optionally) joined across that column.  

thanks

2

Anyone has any ideas on this?

3

Hi Sam,
Ryan’s reply seems to sum it up - have you seen it? How big are you tables? I think a schema change might be warrented.

If I recall correctly,
kx provide the keyword
ej
as a cover function for the functionality that Ryan described since 2.6

I don’t think it is clever with virtual columns etc though, so memory use can be an issue if the tables are big.

Since you say the tables are quite big, you might be a commercial customer. If so, feel free to crosspost to the kx listbox.

Regards,
Andrew