Can you please help,
I'm trying to add the case into my select,
(Select Company From Customers where Customers.ID = Tracking.CustomerID) AS [Client],
(Select CalculatedCost From TrackingModifiers where Tracking.ID = TrackingModifiers.TrackingID
and CASE Name
When Like 'CAN Fuel Surcharge' Then 'CAN Fuel Surcharge'
When Like 'Ad5ress change' Then 'Ad5ress change') END AS [Fuel],
(Select InvoiceNumber From Invoices Where Tracking.InvoiceID = Invoices.ID) AS [Invoice_Number],
(Select InvoiceDate From Invoices Where Tracking.InvoiceID = Invoices.ID) AS [Invoice_Date]
Your help is appreciated.