select * from AM, AR, SA, SM, MR, SR where AR.AR_A=AM.AM_A and AR.AR_A=SA.SA_A and SR.SR_R=MR.MR_R and SR.SR_R=AR.AR_R and AM.AM_M=MR.MR_M and AM.AM_M=SM.SM_M   and SM.SM_S=SA.SA_S and SM.SM_M=SR.SR_S;