You'll have to do the join first and then filter the records with a where clause.
Left Join (Table_1)
load * resident Table_1
where Active_Date >= Effective_Date and Active_Date<Term_Date;
drop table Table_1;
Make sure the date fields are all real dates and not strings.
You could also try to use the intervalmatch function. See this blog post: IntervalMatch