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
