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.