ganapathy.arvindan (5/29/2016)
Another table Table_shift
consider an employee is in the following shift types
D1 to D7 in Dayshift D9 to D13 NightShiftIH D16 to D20 Day shift d21 to D31 nighshift
Now i want to compare Table_shift table with other tables
if he is dayshift compare and calculate working days
if he is nightshiftIH compare and calculate working days
if he is nightshift compare and calculate working days
I think you may be missing giving us details of "Table_shift" data....??
I cant see anything in your table scripts that identifies an "employee"?
can you please post your expected results.....
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day