title: How to do left join and create an indicator for matched/unmatched records?
body: <p>I want to create a left join with indicator, so that for matched records, i can put an indicator 1 and for unmatched records i can put an indicator 0, while selecting the data?</p>