Refer the below SQL sample Query for your reference.
You need to use JOIN.
For common value you can use Inner Join from master table to child table.
SQL
CREATE TABLE #StudentDetails (Id INT,NAME VARCHAR(50))
CREATE TABLE #StudentMarksDetails (Id INT,[Subject] VARCHAR(50),Marks INT)
INSERT INTO #StudentDetails (Id,NAME)
SELECT 1,'Jon'
UNION ALL
SELECT 2,'Vikas'
UNION ALL
SELECT 3,'Vinayak'
INSERT INTO #StudentMarksDetails
SELECT 1,'Marathi',50
UNION ALL
SELECT 1,'Hindi',65
UNION ALL
SELECT 1,'English',80
UNION ALL
SELECT 1,'History',77
UNION ALL
SELECT 1,'Science',60
UNION ALL
SELECT 2,'Marathi',70
UNION ALL
SELECT 2,'Hindi',55
UNION ALL
SELECT 2,'English',70
UNION ALL
SELECT 2,'History',85
UNION ALL
SELECT 2,'Science',75
UNION ALL
SELECT 3,'Marathi',80
UNION ALL
SELECT 3,'Hindi',75
UNION ALL
SELECT 3,'English',85
UNION ALL
SELECT 3,'History',90
UNION ALL
SELECT 3,'Science',85
SELECT SD.Id,SD.NAME
,SMD.[Subject]
,SMD.Marks
FROM #StudentDetails SD
INNER JOIN #StudentMarksDetails SMD
ON SD.Id = SMD.Id
Screenshot
Id |
NAME |
Subject |
Marks |
1 |
Jon |
Marathi |
50 |
1 |
Jon |
Hindi |
65 |
1 |
Jon |
English |
80 |
1 |
Jon |
History |
77 |
1 |
Jon |
Science |
60 |
2 |
Vikas |
Marathi |
70 |
2 |
Vikas |
Hindi |
55 |
2 |
Vikas |
English |
70 |
2 |
Vikas |
History |
85 |
2 |
Vikas |
Science |
75 |
3 |
Vinayak |
Marathi |
80 |
3 |
Vinayak |
Hindi |
75 |
3 |
Vinayak |
English |
85 |
3 |
Vinayak |
History |
90 |
3 |
Vinayak |
Science |
85 |