SELECT     dbo.tInvoice.PlatinumInvoiceNo AS InvoiceNo, dbo.tCustomer.ShipTo, dbo.tCustomer.FullName AS Customer, dbo.tGroup.Description AS [Group], 
                      dbo.tDepartment.Description AS Department, dbo.tCentre.Description AS Centre, dbo.tBatch.ID AS BatchID, dbo.tBatchType.Description AS BatchType, 
                      dbo.tSupplier.SupplierName, dbo.tInvoiceDetail.AmountExGST, dbo.tBatch.BillingPeriod
FROM         dbo.tInvoice INNER JOIN
                      dbo.tInvoiceDetail ON dbo.tInvoice.ID = dbo.tInvoiceDetail.InvoiceID INNER JOIN
                      dbo.tBatch ON dbo.tInvoiceDetail.BatchID = dbo.tBatch.ID INNER JOIN
                      dbo.tBatchType ON dbo.tInvoiceDetail.BatchTypeID = dbo.tBatchType.ID INNER JOIN
                      dbo.tCentre ON dbo.tInvoiceDetail.CentreID = dbo.tCentre.ID INNER JOIN
                      dbo.tDepartment ON dbo.tCentre.DepartmentID = dbo.tDepartment.ID INNER JOIN
                      dbo.tGroup ON dbo.tDepartment.GroupID = dbo.tGroup.ID INNER JOIN
                      dbo.tCustomer ON dbo.tGroup.CustomerID = dbo.tCustomer.ID INNER JOIN
                      dbo.tSupplier ON dbo.tBatch.SupplierID = dbo.tSupplier.ID
WHERE     (dbo.tInvoice.PlatinumInvoiceNo = 'INV018864')