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 |