Need help with how to map 2 tables

[newcharter]

I have  2 tables with columns

Table S:     SName ,SApp, SPrice ,SUsage

Table M:    MName, MApp, MUserCount,Month

Table Map:  SName,SMname

The Map table column S  maps with column S in table S

The Map table column SMname  contains the values  'Not in M' or the Mname value

I need to join both table S and M using table Map

Table S:

s1 : s1name : s1app : s1price : s1usage

s2 : s2name : s2app : s2price : s2usage

s3 : s3name : s3app : s3price : s3usage

Table  M:

M1Name, M1App, M1UserCount,M1Month

M2Name, M2App, M2UserCount,M2Month

Table Map:

S1Name:M1Name

S2Name:'Not in M'

S3Name:M2Name

Please guide me on how i can do this

[GOKULAKANNAN]

Hi @newcharter , 

If my understanding is correct, you can use applymap() function to do that, kindly explain it furthermore,