i have a table named table 1,table data is showed below
| attdate | inime | outtime | workedhours | empid |
| 03-01-17 | 08:30 | 20:00 | 12 | 1 |
| 03-02-17 | 08:30 | 20:00 | 12 | 1 |
| 03-03-17 | 08:30 | 20:00 | 12 | 1 |
| 03-04-17 | 08:30 | 18:30 | 10 | 1 |
| 03-06-17 | 08:30 | 20:10 | 12 | 1 |
03-05-17 date is sunday for march month thats why im not entering into that record in table
i have another table named table 2,record shown below
| empid | leavedate |
| 1 | 03-10-17 |
| 1 | 03-11-17 |
my expected result is like below i want,if worked hours >8 means P ,if employee present in table 2 means L otherwise AB
| empid | 1(03-01-17) | 2 | 3 | 4 | 5... | 10 | 11 |
| 1 | p | p | p | p | p | L | L |
1 means(03-01-17) day 1 for march
2 means day 2 for march