Filter based on list of entries of another table

[clement-1639765]

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? 

[Dawid]

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