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'