Checking Query in SQL

Basit Khan

10y779

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

Below Attendance Table DATA

Thanks

Basit.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vinay Singh10y ago
Hi There is no relation between two tables. please add the foregn key refrence inOperation table and then use inner join to reterive the data
ketan borsdiya10y ago
Then you may check using below query,
SELECT * FROM Operation B
lEFT join Attendance A
on DATEDIFF(day,B.Opn_StartDate,A.Atn_Date)>0 and DATEDIFF(day,B.Opn_EndDate,A.Atn_Date)<0
Basit Khan10y ago
Yes there is no relation but depend upon start and enddate need to make relation
ketan borsdiya10y ago
Hi Basit,
There is no relation between two table. First of all you need to insert relational column in operation table.