Filter element of a table from another table

Need Help
1

Hello,

I would like to filter rows of the table T1.

Table T1 having column A and B (numbers of records 50000)
A(string) | B(int)
word4 | 1254
word4 word2 | 1542
word1 | 47892

Table T2 having column C (numbers of records 200)
C(string)
word1
word2
word3

I would like to display all elements from T1 like this
WORD | NUMBER
word4 | 1254

Explication :
row 2 of T1 is excluded because is having the word “word2” from the table T2
row 3 of T1 is excluded because is having the word “word1” from the table T2

I tried by doing 2 loops, but the performance is so poor : 50000*200.

Do you have another idea ?

Note : No foreign key between the 2 tables.

Thank you for your help.

2

I would try something like this in postgresql:

WHERE A NOT LIKE ALL(ARRAY(SELECT C FROM T2))