Hi again, I am still trying to get to grips with left joins. How would it work for the following query?

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;
[download]

Kind regards!