SQL Join for Supplemental table and Email activity Filter

Hi,

I have a supplemental table that is rewritten a couple of times a day. I want to create an exclusion list that is based in the Email Sent = Today filter so that in the case the import is not successful, it will prevent the email from being sent to those who got the email today.

But, when i go to create the SQL View i am getting an error.

Also, when doing an SQL Join i am not able to choose the Filter.

This is the query:

select  $A$.SOME_FILED from $A$  

left join $B$  on $A$.SOME_FILED = $B$.SOME_FILED