how to merge both side table in linq

Question

tblAttendace

SerailNo	EmployeeCode	Date	working hour
1	x1	25/11/2018	10
2	x1	27/11/2018	10
3	x1	28/11/2018	10

tblPayment

SerailNo	EmployeeCode	Date	Paid
1	x1	25/11/2018	200
2	x1	26/11/2018	200
3	x1	27/11/2018	0

how to merge in linq like

SerailNo	EmployeeCode	Date	working hour	Salary
1	x1	25/11/2018	10	200
2	x1	26/11/2018	0	200
3	x1	27/11/2018	10	200
4	x1	28/11/2018	10	0

Merge both side table 

what if some employee not working on any day but salary paid for those day
and sometime it is work but not paid daily salary,

merge both side table using date using LINQ