Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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,