I've done lots of joins and I understand them. But my understanding gets into the gray area when I see something like this:
RIGHT OUTER JOIN tblSG ON tblDIV.DIVID = tblSG.DIVID
LEFT OUTER JOIN tblDM ON tblSG.DIVID = tblDM.DIVID
LEFT OUTER JOIN tblDAC ON tblSG.DIVID = tblDAC.DIVID
RIGHT OUTER JOIN tblC INNER JOIN tblO ON tblC.CUSTID = tblO.CUSTID
INNER JOIN tblOS ON tblO.ORDERID = tblOS.ORDERID
above is a join within a join "RIGHT OUTER JOIN tblC INNER JOIN tblO ON tblC.CUSTID = tblO.CUSTID"
I don't understand how this works. If someone can give me a run through, that would be great.