Select rows in one table with values identical in another table
I have two tables: tableA and tableB.Rows in one column (say col-1) in tableB has values also occurring in tableA in a column (say col-15). Length or col-15 >> col-1.Can I interactively select the rows in col-15 (of tableA) with entries also occurring in col-1 (of table-B)?If interactive selection is not possible, how to script such a selection process?Thanks.