Table name => The accurate table in the database.
column name => The operations that can be performed in the column.
sql>SELECT cust_id, cust_name FROM cust_det WHERE branch in ('Downtown','Brighton');
sql>SELECT account_number FROM accounts WHERE cust_id IN (SELECT cust_id FROM cust_det WHERE branch ='Downtown' OR branch ='Brighton');
In the above example the sub query will return multiple values and the outer query will search the customer account numbers who have a account in branch ‘Downtown’ or ‘Brighton’.
SQL IN Condition – Is used when we are trying to match a value from a discrete value set.