Can we write inner join between transparent table and cluster table? If both having common fields?
We can only use inner join in Transparent table not in pool or Cluster Table.