Assuming you do not have two operations with overlapping dates, try this:
Select *
from operation o
left outer join Attendance a on a.atn_date >= o.opn_startdate and a.atn_date <= o.opn_enddate
If you have overlapping operations, then you'll need to put SOMETHING in your database to link the two records.