Consider the following table named STUDENT

and the next table INSTITUTE

which have a relationship by the field ID_INSTITUTE
What is the query that would produce the following result set:

Question

Consider the following table named STUDENT   
  
   
   
   
   
   
 and the next table INSTITUTE 
  
   
   
   
   
 which have a relationship by the field ID_INSTITUTE 
 What is the query that would produce the following result set:

Accepted Answer

SELECT  STUDENT.NAME [NAME OF STUDENT], INSTITUTE.NAME [NAME OF INSTITUTE] 
 FROM  STUDENT  FULL JOIN  INSTITUTE 
 ON  STUDENT.ID_INSTITUTE=INSTITUTE.ID

Answer

SELECT  STUDENT.NAME [NAME OF STUDENT], INSTITUTE.NAME [NAME OF INSTITUTE] 
 FROM  STUDENT  LEFT JOIN  INSTITUTE 
 ON  STUDENT.ID_INSTITUTE=INSTITUTE.ID

Answer

SELECT  STUDENT.NAME [NAME OF STUDENT], INSTITUTE.NAME [NAME OF INSTITUTE] 
 FROM  INSTITUTE  RIGHT JOIN  STUDENT 
 ON  INSTITUTE.ID = STUDENT.ID_INSTITUTE

Answer

SELECT  STUDENT.NAME [NAME OF STUDENT], INSTITUTE.NAME [NAME OF INSTITUTE] 
 FROM  STUDENT, INSTITUTE 
 WHERE  STUDENT.ID_INSTITUTE=INSTITUTE.ID

Answer

SELECT  STUDENT.NAME [NAME OF STUDENT], INSTITUTE.NAME [NAME OF INSTITUTE] 
 FROM  STUDENT  JOIN  INSTITUTE 
 ON  STUDENT.ID_INSTITUTE=INSTITUTE.ID

ID	NAME	ID_INSTITUTE	RATING
1	Левицький А.
2	Стернюк У.	I1	3.8
3	Войтенко М.	I2	3.5
4	Бабич О.	I2	4.1

ID	NAME
I1	Computer science
I2	Mathematics
I3	Physics

NAME OF STUDENT	NAME OF INSTITUTE
Левицький А.	NULL
Стернюк У.	Computer science
Войтенко М.	Mathematics
Бабич О.	Mathematics
NULL	Physics

Crowdly

Consider the following table named STUDENT and the ne...

Want instant access to all verified answers on softserve.academy?