CREATE TABLE [dbo].[PurchasedProducts](
	[ProductID] [int] NULL,
	[TransactionID] [int] NULL
)
GO


CREATE TABLE [dbo].[Products](
	[ProductID] [int] NULL,
	[ProductName] [varchar](100) NULL,
	[Price] [int] NULL
)
GO

CREATE TABLE [dbo].[TransactionTbl](
	[TransactionID] [int] NULL,
	[TotalAmount] [int] NULL,
	[TransactionDate] [date] NULL
)
GO

INSERT INTO Products 
VALUES 
(1,'Product_A',100),
(2,'Product_B',200),
(3,'Product_C',300),
(4,'Product_D',400),
(5,'Product_E',500);

INSERT INTO TransactionTbl
VALUES
(1001,1000,GETDATE()-2),
(1002,900,GETDATE()-1),
(1003,800,GETDATE())

INSERT INTO PurchasedProducts
VALUES
(1,1001),(2,1001),(3,1001),(4,1001),
(4,1002),(5,1002),
(3,1003),(5,1003)

SELECT tt.TransactionID,tt.TransactionDate,p.ProductName,tt.TotalAmount
FROM TransactionTbl tt 
INNER JOIN PurchasedProducts pp on tt.TransactionID = pp.TransactionID
INNER JOIN Products p on p.ProductID = pp.ProductID