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
replied on February 11, 2024

Is this still not supported? Such a basic functionality should be available to build queries. Joins and Unions at the least.

 

We should be able to write our own SQL code. I understand it's supposed to be easy for anyone to be able to learn the LF Cloud platform quickly, but there should be more expert tools available. 

 

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

Sign in to reply to this post.