Can we use cluster tables in join?
Can we use cluster tables in table joins?
Marcin Pciak replied
As far as I know cluster tables can be read using IMPORT statement, macros, or specific FMs. You can't extract them directly using simple SELECT, thus joining is not allowed here two.
Nevetherless you are able to do join on internal tables which stores already extracted cluster tables. PROVIDE statement is the one to be used here.