New Search
SELECT GL_MASTER.FUND_CODE, GL_MASTER.ACCOUNT, GL_MASTER.ACCT_PERIOD, GL_DETAIL.JE_DESC, GL_DETAIL.JE_AMOUNT <br />FROM QUERY_GL.dbo.GL_DETAIL GL_DETAIL, QUERY_GL.dbo.GL_MASTER GL_MASTER <br />WHERE GL_DETAIL.ACCOUNT = GL_MASTER.ACCOUNT AND GL_DETAIL.ACCT_PERIOD = GL_MASTER.ACCT_PERIOD AND GL_DETAIL.CLASS_FLD = GL_MASTER.CLASS_FLD <br />AND GL_DETAIL.DEPTID = GL_MASTER.DEPTID AND GL_DETAIL.FISCAL_YEAR = GL_MASTER.FISCAL_YEAR AND GL_DETAIL.FUND_CODE = GL_MASTER.FUND_CODE <br />AND GL_DETAIL.PROGRAM_CODE = GL_MASTER.PROGRAM_CODE AND GL_DETAIL.PROJECT_ID = GL_MASTER.PROJECT_ID AND ((GL_MASTER.FISCAL_YEAR='2013') <br />AND (GL_MASTER.FUND_CODE Like '33%') AND (GL_MASTER.ACCT_PERIOD In (4,5,6)) AND (GL_MASTER.ACCOUNT In ('47125','47126'))) <br />