Multiple rows coming back - Cartesian

Hi,

I started another report to just find Invoices and match up to GLTRANS and ACHISTHDR and ACHISTDTL.  The only thing I am getting from ACHISTHDR is the Invoice date.

According to the data dictionary the joins should be this, but like I mentioned - I am getting mutliple rows for one record even though everything is inner joins.

Does anyone see something wrong with this from clause?


FROM LAW9_ACHISTHDR INNER JOIN (LAW9_ACHISTDTL INNER JOIN (LAW9_GLTRANS INNER JOIN LAW9_GLSYSTEM ON LAW9_GLTRANS.COMPANY = LAW9_GLSYSTEM.COMPANY) ON LAW9_ACHISTDTL.GLT_OBJ_ID = LAW9_GLTRANS.OBJ_ID) ON LAW9_ACHISTHDR.OBJ_ID = LAW9_ACHISTDTL.OBJ_ID

Thanks!