You are viewing limited content. For full access, please sign in.

Question

Question

How to select multiple lookup tables in query builder...

asked on December 5, 2022

I'm trying to select 2 tables (Cloud LF Lookup Tables) and write the query (similar to an inner join) to return the data. However, I can only select 1 table in the query builder. If I select another table, Add is not available, until I remove the first table.

If I do try to add the tables and set the WHERE and ORDER BY (by adding and then removing tables), it shows an error because not all tables are in the "Selected Tables" window.

Any thoughts on how I can do a lookup on 2 tables that are joined together?

thanks,

Brian

0 0

Replies

replied on December 5, 2022

This is not currently supported.

0 0
replied on December 5, 2022

Does anyone know of a work-around until it would be supported?

I have 3 tables that I need to create the query for. The only way I can think of would be to manually put these tables together to then reference, which would not be ideal every time there is an update to any table.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.