Hi all,I am trying to how i can achieve the following in lookerI have 2 tables, Table_A and Table_B I would like to do something as followSELECT * from Table_A WHERE field1 IN ( SELECT field1 from Table_B WHERE field2 = 'value1') Follow up would be, ...