Showing results for 
Show  only  | Search instead for 
Did you mean: 

Is it possible to join tables using AQL?


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?


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?

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,


Found something helpful? Click the Accept as Solution button to help others find answers faster.
Liked something? Click the Thumbs Up button.