Filter based on list of entries of another table

Looker Q&A Looker
1

Hi all,

I am trying to how i can achieve the following in looker

  1. I have 2 tables, Table_A and Table_B
  2. I would like to do something as follow
SELECT * from Table_A WHERE field1 IN (
     SELECT field1 from Table_B WHERE field2 = 'value1'
)

Follow up would be, is it possible to set value1 dynamically?

2

You can do that by creating two views and joining them using INNER JOIN. Value1 can be a parameter or you can just use it as a filter based on values from field2

1 Like