Is it possible to join tables using AQL?

[kyzhou]

I have a table of IDs to Names:

id: name

1: user1

2: user2

3: user3

and another table of more data:

id: edu : ......

1 : bachelor : ....

2 : master : ....

3 : phd : ....

Is it possible to use AQL to join these two together so I can display the name corresponding to an id in a search?

[kyzhou]

No, I do not have an EUM license. I was asking for Analytics tables in general.

How should we structure a search to select from multiple tables? Do they need to share the exact same rows, or just a subset?

[Chitra.Lal]

Hi Kyzhou,

As you don't have an EUM license hence this 401 error you see. You need to have EUM license to use browser_records and synth data. 

Now regarding your original query we can not select data to be shown from multiple tables unless they are from the same schema. Iff two tables that you are trying to see are in the same schema can you structure a query to fetch data combining both, but not in any other case. 

Hope that clarifies. Do let me know in case you have further queries. 

Thank You,

Chitra