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

Is it possible to join tables using AQL?

kyzhou
Builder

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?

11 REPLIES 11

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,

Chitra



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