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