i have a table called sample,table date like below
| attendencedate |
| 03-01-14 |
| 03-02-14 |
| 03-03-14 |
i have another table called table2
| leavedate |
| 03-04-14 |
| 03-05-14 |
| 03-06-14 |
my expected result is
if date is present in table1 means p otherwise L
| dates | ispresent |
| 03-01-14 | p |
| 03-02-14 | p |
| 03-03-14 | p |
| 03-04-14 | L |
| 03-05-14 | L |
| 03-06-14 | L |
Ramesh BarikPosted Apr 8, 2017, 9:09 AM