Looking for an alternative SQL command to find the same values in two tables

Question

I am using this command to find the same values in two tables when the tables have 100-200 records. But When the tables have 100000-20000 records, the sql manager, browsers, shortly the computer is freesing.

Is there any alternative command for this?

SELECT
distinct
names
FROM
table1
WHERE
names in (SELECT names FROM table2)

Answer 1

Try with join

SELECT distinct t1.names
FROM table1 t1
join table2 t2 on t2.names = t1.names

Answer 2

Use EXISTS:

SELECT distinct t1.names
FROM Table1 t1
WHERE EXISTS(
    SELECT 1 FROM tabl2 t2 WHERE t2.names=t1.names
)