Unnamed

SELECT tbl_DetailCalls_Rated.ratedcallsseq,	tbl_Transactions.transactionfromdate, tbl_Transactions.transactiontodate,		tbl_Transactions.description1, 	tbl_Departments.DeptId, tbl_UserInfo.UserId, 	tbl_InvoiceSummary.InvoiceStatus, tbl_Transactions.TransactionDate, 	tbl_Departments.Description, tbl_Transactions.TotalAmount, 	tbl_DirectoryNumbers.DirectoryNbr, tbl_UserInfo.FirstName, 	tbl_UserInfo.LastName, tbl_DetailCalls_Rated.DateOfCall, 	tbl_DetailCalls_Rated.TermCity, tbl_DetailCalls_Rated.TermState, 	tbl_DetailCalls_Rated.TermAreaExchange, 	tbl_DetailCalls_Rated.TermPhoneNumber, 	tbl_DetailCalls_Rated.RatedAmount1, tbl_UserInfo.UserSeq, 	tbl_InvoiceSummary.InvoiceSummarySeq, 	tbl_Transactions.CallDuration, 	tbl_DetailCalls_Rated.RoundedDuration1, 	tbl_Transactions.CallCount, tbl_UserNumbers.UserNumber, 	tbl_Branches.DeptId as BranchDeptID, tbl_Departments.DeptSeq, 	tbl_TransactionCode.DebitCreditPayment, 	tbl_UserNumbers.UserNumberType, 	tbl_DetailCalls_Rated.OrigAreaExchange, 	tbl_DetailCalls_Rated.OrigPhoneNumber, 	tbl_DetailCalls_Rated.OrigCity, 	tbl_DetailCalls_Rated.OrigState, tbl_UserInfo.AccountSeq, 	tbl_CycleHistory.CallToDate, tbl_DetailCalls_Rated.SwitchSeq, 	tbl_CycleHistory.InvoiceDate, tbl_CycleHistory.InvoiceFromDate, 	tbl_CycleHistory.InvoiceToDateFROM ((((((((tbl_CycleHistory tbl_CycleHistory INNER JOIN tbl_InvoiceSummary tbl_InvoiceSummary 	ON tbl_CycleHistory.CycleHistorySeq=tbl_InvoiceSummary.CycleHistorySeq)LEFT OUTER JOIN tbl_Transactions tbl_Transactions 	ON tbl_InvoiceSummary.InvoiceSummarySeq=tbl_Transactions.InvoiceSummarySeq) LEFT OUTER JOIN tbl_TransactionCode tbl_TransactionCode 	ON tbl_Transactions.TranCodeSeq=tbl_TransactionCode.TranCodeSeq) LEFT OUTER JOIN tbl_DetailCalls_Rated tbl_DetailCalls_Rated 	ON tbl_Transactions.TransactionSeq=tbl_DetailCalls_Rated.TransactionSeq) INNER JOIN tbl_UserInfo tbl_UserInfo 	ON tbl_Transactions.UserSeq=tbl_UserInfo.UserSeq) LEFT OUTER JOIN tbl_Departments tbl_Departments 	ON tbl_UserInfo.DeptSeq=tbl_Departments.DeptSeq) LEFT OUTER JOIN tbl_DirectoryNumbers tbl_DirectoryNumbers 	ON tbl_UserInfo.DirectoryNbrSeq=tbl_DirectoryNumbers.DirectoryNbrSeq) INNER JOIN tbl_Departments tbl_Branches 	ON tbl_Departments.ParentSeq=tbl_Branches.DeptSeq) LEFT OUTER JOIN tbl_UserNumbers tbl_UserNumbers 	ON tbl_DetailCalls_Rated.UserNumberSeq=tbl_UserNumbers.UserNumberSeq			WHERE  	tbl_InvoiceSummary.InvoiceStatus='L' 	AND tbl_UserInfo.AccountSeq=1	AND left(tbl_Departments.DEPTID,6)='123456'ORDER BY tbl_Branches.DeptId, tbl_Departments.DeptId, 	tbl_UserInfo.UserId, tbl_UserNumbers.UserNumber, 	tbl_DetailCalls_Rated.DateOfCall