SELECT TOP 100 PERCENT dbo.tElement.Description AS Element, dbo.tServiceID.ServiceID AS ServiceIDDesc, dbo.tInvoiceDetail.BatchID AS Batch, dbo.tBatchType.SupplierDisplayedName, dbo.tLocation.Description AS Location, dbo.tPerson.Person, dbo.tCentre.Description AS CustCentre, dbo.tActivity.Description AS CustActivity, tElement_1.Description AS CustElement, dbo.tSubledger.Description AS CustSubledger, dbo.tFinalisedTransaction201102.PayType, dbo.tServiceType.Description AS ServiceType, dbo.tInvoiceDetail.Description AS InvDetailDesc, dbo.tInvoiceDetail.Period, dbo.tCustomer.ShipTo, dbo.tInvoice.PlatinumInvoiceNo, dbo.tFinalisedTransaction201102.AmountExGST AS ExGST, dbo.tFinalisedTransaction201102.GSTAmount AS GST, dbo.tFinalisedTransaction201102.AmountIncGST AS IncGST, dbo.tTransactionGroup.Description AS TxnGrp, dbo.tFinalisedTransaction201102.Var01, dbo.tFinalisedTransaction201102.Var02, dbo.tFinalisedTransaction201102.Var03, dbo.tFinalisedTransaction201102.Var04, dbo.tFinalisedTransaction201102.Var05, dbo.tBatchType.Description, dbo.tReportGroup.GroupDesc, dbo.tDepartment.Description AS DeptDesc, dbo.tFinalisedTransaction201102.ID FROM dbo.tServiceType RIGHT OUTER JOIN dbo.tLocation RIGHT OUTER JOIN dbo.tPerson RIGHT OUTER JOIN dbo.tTransactionGroup RIGHT OUTER JOIN dbo.tTransactionType ON dbo.tTransactionGroup.ID = dbo.tTransactionType.TransactionGroupID RIGHT OUTER JOIN dbo.tDepartment RIGHT OUTER JOIN dbo.tCentre RIGHT OUTER JOIN dbo.tInvoice WITH (NOLOCK) INNER JOIN dbo.tInvoiceDetail WITH (NOLOCK) ON dbo.tInvoice.ID = dbo.tInvoiceDetail.InvoiceID INNER JOIN dbo.tServiceID INNER JOIN dbo.tFinalisedTransaction201102 ON dbo.tServiceID.ID = dbo.tFinalisedTransaction201102.ServiceID ON dbo.tInvoiceDetail.ID = dbo.tFinalisedTransaction201102.InvoiceDetailID LEFT OUTER JOIN dbo.tBatchType WITH (NOLOCK) ON dbo.tFinalisedTransaction201102.BatchID = dbo.tBatchType.ID LEFT OUTER JOIN dbo.tReportGroup ON dbo.tBatchType.ReportGroupID = dbo.tReportGroup.ID LEFT OUTER JOIN dbo.tCustomer ON dbo.tFinalisedTransaction201102.CustomerID = dbo.tCustomer.ID LEFT OUTER JOIN dbo.tElement tElement_1 ON dbo.tFinalisedTransaction201102.CustomerElementID = tElement_1.ID LEFT OUTER JOIN dbo.tActivity ON dbo.tFinalisedTransaction201102.CustomerActivityID = dbo.tActivity.ID LEFT OUTER JOIN dbo.tSubledger ON dbo.tFinalisedTransaction201102.CustomerSubledgerID = dbo.tSubledger.ID ON dbo.tCentre.ID = dbo.tFinalisedTransaction201102.CustomerCentreID ON dbo.tDepartment.ID = dbo.tCentre.DepartmentID ON dbo.tTransactionType.ID = dbo.tFinalisedTransaction201102.TransactionTypeID ON dbo.tPerson.ID = dbo.tFinalisedTransaction201102.PersonID ON dbo.tLocation.ID = dbo.tFinalisedTransaction201102.LocationID LEFT OUTER JOIN dbo.tElement ON dbo.tFinalisedTransaction201102.ElementID = dbo.tElement.ID ON dbo.tServiceType.ID = dbo.tFinalisedTransaction201102.ServiceTypeID WHERE dbo.tInvoice.PlatinumInvoiceNo = 'INV010505'