SQLize Online / PHPize Online  /  SQLtest Online

SELECT [Run].[RunID], [Parts].[CustomerID], [Parts].[fab_area], [Run].[SetDescription], [Run].[StartDate], [Run].[StopDate], [Run].[Status], [Run].[Site], [Run].[ProcessValue], [PurchaseOrder].[CustomerPO], [PurchaseOrder].[Date] AS [PO_Date], [Run].[OnHold], REPLACE(REPLACE(WIPComments, CHAR(13), ''), CHAR(10), '') as WIPCommentsCRRemoved FROM [Run] INNER JOIN [PurchaseOrderItem] ON [Run].[PurchaseOrderItemID] = [PurchaseOrderItem].[PurchaseOrderItemID] INNER JOIN [PurchaseOrder] ON [PurchaseOrderItem].[PurchaseOrderID] = [PurchaseOrder].[PurchaseOrderID] INNER JOIN [Parts] ON [Run].[SetPartID] = [Parts].[PartID] INNER JOIN [Customers] ON [Parts].[CustomerID] = [Customers].[CustomerID] WHERE ([Run].[StartDate] >'01 JAN 2023' and [Run].[SetDescription] like '0247%' and [Parts].[fab_area] <> 'IMP')