คิวรี่ข้อมูล จากฐานข้อมูล ต้องการให้ได้ผลลัพธ์มาแ่ค่บรรทัดเดียวอ่ะค่ะ

-- BEGINNING TEST DATA
USE [test]
GO


-- BEGIN : CREATE TABLE SECTION
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[simple_document_header]') AND type in (N'U'))
DROP TABLE [dbo].[simple_document_header]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[simple_document_header](
	[id] [int] NOT NULL,
	[name] [varchar](50) NULL,
 CONSTRAINT [PK_simple_document_header] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[simple_document_flow]') AND type in (N'U'))
DROP TABLE [dbo].[simple_document_flow]
GO

CREATE TABLE [dbo].[simple_document_flow](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[document_id] int NULL ,
	[receive_date_time] datetime NULL ,
	[user_name] [varchar](50) NULL,
 CONSTRAINT [PK_simple_document_flow] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO
-- END : CREATE TABLE SECTION

-- BEGIN : INSERT DUMMY DATA 

INSERT INTO [test].[dbo].[simple_document_header]
           ([id] ,[name])
     VALUES
           (1 ,'Account article no:191') ,
           (2 ,'Account article no:562') ,
           (3 ,'Inventory request : 141') 
GO



INSERT INTO [test].[dbo].[simple_document_flow]
           ([document_id]
           ,[receive_date_time]
           ,[user_name])
     VALUES
           (1 , DATEADD ( DAY ,-1 , GETDATE()) ,'Nena') ,
           (1 , DATEADD ( DAY ,-2 , GETDATE()) ,'Anne') ,
           (1 , DATEADD ( DAY ,-3 , GETDATE()) ,'Cifer') ,
           (2 , DATEADD ( DAY ,-2 , GETDATE()) ,'Natt') ,
           (2 , DATEADD ( DAY ,-4 , GETDATE()) ,'Bree') ,
           (2 , DATEADD ( DAY ,-5 , GETDATE()) ,'Brom') ,
           (2 , DATEADD ( DAY ,-6 , GETDATE()) ,'Briona') ,
           (3 , DATEADD ( DAY ,-2 , GETDATE()) ,'Karl') 
GO

SELECT * 
FROM [simple_document_header] AS [Header];

SELECT [id] ,[document_id] , convert(varchar ,[receive_date_time],109) ,[user_name] 
FROM [simple_document_flow] AS [Flow] ;

SELECT  [Header].* ,[Complicate_Flow].*
FROM [simple_document_header] AS [Header]
CROSS APPLY 
(
	SELECT TOP 1 *
	FROM [simple_document_flow] AS [Flow]
	WHERE [Flow].[document_id] = [Header].[id]  
	ORDER BY [receive_date_time] 
) AS [Complicate_Flow]
;

-- END : INSERT DUMMY DATA


-- BEGIN : CLEAR TABLE SECTION
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[simple_document_header]') AND type in (N'U'))
DROP TABLE [dbo].[simple_document_header]
GO

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[simple_document_flow]') AND type in (N'U'))
DROP TABLE [dbo].[simple_document_flow]
GO
-- END : CLEAR TABLE SECTION