I know JOINs are not supported, but have seen that you can simulate it with FACET if the two tables have the same column/attribute name.
A, B FACET sharedId, B.otherStuff
SINCE 1 MONTH AGO LIMIT MAX
Assuming A and B both have an attribute called sharedId.
However, what if the attribute names are different in the two tables, even though they are the same data. What is the syntax then?
A.join_id and B.my_join_id are the same unique ID to ‘join’ the table, but their names are different (join_id versus my_join_id). I can’t use the syntax in the query above, unless there is a workaround using as or something?