Combine tables without common entry

[#1]

Hi Team,

I have two table :

Table1: Holds all employee details without  0 planning hours(<>0)

Table2: Hold all employees with zero planning hours.(=0)

Fileds name-Employee name,Project code,week,planning hours.

So there are chances that employees in table 1 may be in table 2 for some week.

Hence, I wont a table which holds data from table1 and table 2 but make sure

In case there are same employee in table1 and table2 , we should keep the one in table 1(<>0).

Kindly assist.

Thanks,

Prajna

[#2]

Sorry some syntax problem..i corrected.Its coming.

But does it give employees from table 1 alone,I need employees in table 2 as well .

in case they are not present in table1.

As per example Ramya.I am not getting employees with 0 hours.

Regards,

Prajna