I have a table called Attendance
Atn_No int
Atn_Date date
Atn_EmpNo varchar
I have another table Called Operation
Opn_No int
OPn_StartDate date
Opn_EndDate date
Opn_Activity varchar
Opn_ActivityHour int
What i want to check with Operation with the help Start & End Date Who's employees was working on that operation
Below is Operation Table DATA
| Opn_StartDate | Opn_EndDate | Opn_Activity | Opn_ActivityHour |
| 01-01-2016 | 03-01-2016 | ABC | 1 |
| 04-01-2016 | 06-01-2016 | XYZ | 2 |
| 07-01-2016 | 08-01-2016 | LMN | 3 |
Below Attendance Table DATA
| Atn_No | Atn_Date | Atn_EmpNo |
| Atn-1 | 02-01-2016 | A-1 |
| Atn-2 | 02-01-2016 | A-2 |
| Atn_3 | 05-01-2016 | A-3 |
Thanks
Basit.