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')