SELECT Resultado.*,CargoWise.*#(lf)FROM (SELECT [FreightForwarder] as SP_FreightForwarder,[CustomerReference] AS SP_CustomerReference#(lf)      ,[ShipperName] as SP_ShipperName,[ConsigneeName] as SP_ConsigneeName,[HBL/HAWB] as SP_HBL,[MOT] as SP_MOT,[Origin] as SPOrigin#(lf)      ,[POL] as SP_POL,[Destination] as SPDestination,[POD] as SP_POD,[CarrierName] as SP_CarrierName,[ArrivalVessel ] as SP_ArrivalVessel,[ContainerNumber] as SP_ContainerNumber#(lf)      ,[ContainerType] as SP_ContainerType,[Volume] as SPVolume,[Weight] as SPPeso,[CargoReadyDate] as SP_CargoReadyDate,[ETD] as SP_ETD#(lf)      ,[ETA] as SP_ETA,[ShipmentsOrderStatus] as SP_ShipmentsOrderStatus,[Customer] as SP_Customer,NULL as SP_AddRef,NULL as SP_QuoteID,NULL as SP_ConfirmationDate#(lf)#(tab)  ,NULL as SP_BookingDate,NULL as SP_BookingConfirmation,NULL as SP_Prealert,NULL as SP_Invoice,NULL as SP_ContractID#(lf)#(tab)  ,NULL as SP_Currency,NULL as SP_CarrierRef,NULL as SP_Unloading,NULL as [Notification],NULL as SP_NroContenedor#(lf)      ,NULL as SP_NaveTransbordo,NULL as SP_FechaTransbordo,NULL as SP_PuertoTransbordo,NULL as SP_HBLEmDest,NULL as SP_FreightCost#(lf)#(tab)  ,NULL as SP_ClienteStatus,NULL as SP_FechaAprobacion,NULL as SP_idShipments,NULL as SP_TerceraRef,NULL as SP_TEUS#(lf)FROM ControlTower#(lf)#(lf)UNION SELECT 'Sparx Logistics',[CustomRef]#(lf)#(tab)#(tab)  ,[ShipperName],[Consignee],[HBL],[MOT],[Origin]#(lf)#(tab)#(tab)  ,[POL],[Destination],[POD],[Carrier],[VesselFlight],[NroContenedor]#(lf)#(tab)#(tab)  ,[Contenedores],[VolumeCBM],[Peso],[CargoReady],[ETD]#(lf)#(tab)#(tab)  ,[ETA],[Status],[Customer],[AddRef],[QuoteID],[ConfirmationDate],[BookingDate],[BookingConfirmation]#(lf)#(tab)#(tab)  ,[Prealert],[Invoice],[ContractID],[Currency],[CarrierRef],[Unloading],[Notification],[NroContenedor]#(lf)#(tab)#(tab)  ,[NaveTrasbordo],[FechaTransbordo],[PuertoTransbordo],[HBLEmDest],[FreightCost],[ClienteStatus]#(lf)#(tab)#(tab)  ,[FechaAprobacion],[idSPShipments],[TerceraRef],[TEUS]#(lf)FROM SPShipments) AS Resultado LEFT JOIN CargoWise ON Resultado.SP_HBL = CargoWise.[CW_Shipments#House Ref]"