1.


       SELECT        gl.TxDate, gl.Reference, gl.AccCode, a.Description, gl.TxDate AS Expr1, gl.Description AS TransactionDetails, gl.Debit, gl.Credit, gl.AuditNr, gl.[User], concat(u.FirstName,' ',u.LastName) as UserName

FROM            [GRW Engineering].dbo.PostGL AS gl 

      INNER JOIN

                         [GRW Engineering].dbo.GLAccounts AS a ON gl.AccCode = a.AccCode

      inner join [GRW Engineering].dbo.[USERS] as u

        on u.Code = gl.[User]

   

WHERE        (gl.TxType LIKE 'gj%') AND (gl.TxDate >= CONVERT(DATETIME, '01/08/2019', 103)) AND (gl.TxDate < CONVERT(DATETIME, '01/08/2020', 103))

Created with the Personal Edition of HelpNDoc: Upgrade your help files and your workflow with HelpNDoc's WinHelp HLP to CHM conversion