Write a SQL query to get FirstName, Lastname, Scholarship amount from tblStudent and tblScholarship table for all students even if they didn’t get Scolarship
Introduction
Write a SQL query to get FirstName, Lastname, Scholarship amount from tblStudent and tblScholarship table for all students even if they didn’t get Scolarship. I have used Microsoft SQL server 2008 R2 for the following demo.
– tblstudent
StudentId
FirstName
LastName
Admission_fee
Admission_date
Branch
1
John
Smith
1000
2018-06-10
Computer Engineering
2
David
Jones
1200
2018-06-20
Civil Engineering
3
Michael
Johnson
900
2018-08-15
Chemical Engineering
4
Chris
Lee
1500
2018-07-10
Electrical Engineering
5
Mike
Brown
1600
2018-09-10
Mechanical Engineering
6
Lisa
Smith
1800
2018-07-10
Computer Engineering
7
Mary
Smith
1600
2018-06-11
Computer Engineering
– tblScholarship
Student_ref_id
Scholarship_Date
Scholarship_Amount
1
2018-10-09
100
2
2018-11-10
150
3
2018-12-12
200
4
2019-01-05
100
5
2019-02-25
150
6
2019-03-15
NULL
7
2019-04-23
110
SELECT Firstname, Lastname, Scholarship_Amount
FROM tblStudent A LEFT JOIN tblScholarship B
ON A.StudentId = B.Student_ref_id
Result
Write a SQL query to get FirstName, Lastname, Scholarship amount from tblStudent and tblScholarship table for all students even if they didn’t get Scolarship