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?