Q:

Select FirstName, Lastname, Scholarship amount from tblStudent and tblScholarship table for all students even if they didn’t get Scolarship.

0

Select FirstName, Lastname, Scholarship amount from tblStudent and tblScholarship table for all students even if they didn’t get Scolarship.

All Answers

need an explanation for this answer? contact us directly to get an explanation for this answer

Select Firstname, Lastname, Scholarship_Amount from tblStudent A left join tblScholarship
 B on A.StudentId = B.Student_ref_id

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)

Top 100 SQL server queries Interview questions

This question belongs to these collections

Similar questions


need a help?


find thousands of online teachers now
Select FirstName, Lastname, Scholarship amount fro... >>
<< Select no of students joined with respect to year ...