You have two following tables FacSSN FacName 111-11-1111 John Doe 222-22-2222 Ma
ID: 3849066 • Letter: Y
Question
You have two following tables
FacSSN
FacName
111-11-1111
John Doe
222-22-2222
Maggie Smith
333-33-3333
David King
OfferingNo
CourseNo
FacSSN
12345
MIS 301
111-11-1111
12346
MIS 302
222-22-2222
12347
MIS 310
222-22-2222
12348
MIS 320
After running a query the output is
FacSSN
FacName
CourseNo
111-11-1111
John Doe
MIS 301
222-22-2222
Maggie Smith
MIS 302
222-22-2222
Maggie Smith
MIS 310
333-33-3333
David King
The query is of type __________
1. Left join
2.Right join
3.ehither left or right join
4.inner join
5.we need more information
FacSSN
FacName
111-11-1111
John Doe
222-22-2222
Maggie Smith
333-33-3333
David King
Explanation / Answer
the query is of type -------(1)left join.
why because. the result table conatins all common fields of two tables(table1.FacSSN=table2.FacSSN). and remaining record of table1 are displayed in resulting table. that's why it is left join.
the query is like as "select FacSSN,FacName,CourseNo Table1 left join Table2 on table1.FacSSN=Table2.FacSSN"
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.