Question: The student and session table has two identical columns, US and dassid , which two(2) of the following statements joins these tables bases on common

The student and session table has two identical columns, US and dassid , which two(2) of the following statements joins these tables bases on common US and classid values? Select one or more Ja select from student inner join session on studentusi sessions and student classid = Session classid: Ob select firstname from student natural join left session cselect * from student inner join session using(usiclassid); Od select firstname from student natural join inner session Which two(2) of the following statements are syntactically correct? Select one or more Da select firstname from student join session using us.classid b. select firstname from student right join outer session using(usi, classid). select firstname from student left outer join session using(usiclassid Od select firstname from student cross join session using usi classid)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
