ON GE.Gid = GE_SI_SO.Gid AND GE.(ORDER BY GE.Gid, GE.EventOn) RowNumber, GE.Gid, GE.[Type]WHERE GE.IsDeleted = 0) GE_O ON GE_BASE.Gid = GE_O.Gid AND
GE</em
SELECT Ge.LoanAgreementID, Ge.Amount, Ge.ContactID, Ge.TransactionDate, Lo.AutoNumber, Ge.GeneralLedgerTypeFROM GeneralLedger as GeGROUP BYGe.ContactID HAVING CO