'I am using this Query function but it is not working well

I have 3 sheets in this spreadsheet.

Data : Main Dataset
Data 2: 2nd Dataset
Data after removing Data 2: I want to filter out Main Dataset(Data sheet) that is not in 2nd Dataset.

I am using this but not working.

Any other method? that will solve my problem?

Solution 1:^[1]

use:

=QUERY(Data!A1:K, "where not B matches '"&TEXTJOIN("|", 1,'Data 2'!B1:B)&"'")

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source
Solution 1	player0