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

YasminRadwan26

Save to bookmark

2022-05-13

1066

Database, Sql programming, Interview questions, Database Interview-questions, Sql programming Interview-questions,

YasminRadwan26

2022-05-13

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)