siva nathan

siva nathan

  • 901
  • 828
  • 228.8k

how to select date column from another table

Apr 8 2017 6:29 AM
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
 

Answers (1)