Basit Khan

Basit Khan

  • NA
  • 336
  • 122.4k

Checking Query in SQL

Aug 31 2016 6:01 AM
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. 

Answers (4)