Compare two tables and two columns

[yoganantha321]

Hi,

I have two tables :

table 1: It contains all the dates in the month as shown below: ( Example: 01/01/2017 to 01/31/2017) of January month

But employee was present in the below dates only as shown in images:

table 2:

I need the output as combining of the two dates and not matched as '-' or null as shown below

image 3:

comparing from table 1 and table 2 the employee 138 did not attend the office on 01/01/2017 and 01/08/2017.

As image 3 i need output.

Can any one help me

regards

Yoganantha Prakash G P

[Sergey_Shuklin]

Hello!

Try to use left join on that:

Table 1 left join Table 2 on two fields Emp and Date. You will get null rows for hours.

[Sergey_Shuklin]

It's funny that Siva has the same request =D

How to compare two columns in two tables‌

[yoganantha321]

hi sergery,

I am getting output like this

[yoganantha321]

hi,

If i tested with some sample data i am getting output. But as per my original data it is not working.

I have attached my data along with this...

Please anybody help in this....

Regards,

Yoganantha Prakash G P