SELECT STUDENT.NAME [NAME OF STUDENT], INSTITUTE.NAME [NAME OF INSTITUTE]

FROM STUDENT LEFT JOIN INSTITUTE

ON STUDENT.ID_INSTITUTE=INSTITUTE.ID

SELECT STUDENT.NAME [NAME OF STUDENT], INSTITUTE.NAME [NAME OF INSTITUTE]

FROM STUDENT, INSTITUTE

WHERE STUDENT.ID_INSTITUTE=INSTITUTE.ID

SELECT STUDENT.NAME [NAME OF STUDENT], INSTITUTE.NAME [NAME OF INSTITUTE]

FROM STUDENT JOIN INSTITUTE

ON STUDENT.ID_INSTITUTE=INSTITUTE.ID

SELECT STUDENT.NAME [NAME OF STUDENT], INSTITUTE.NAME [NAME OF INSTITUTE]

FROM INSTITUTE RIGHT JOIN STUDENT

ON INSTITUTE.ID = STUDENT.ID_INSTITUTE

SELECT STUDENT.NAME [NAME OF STUDENT], INSTITUTE.NAME [NAME OF INSTITUTE]

FROM STUDENT FULL JOIN INSTITUTE

ON STUDENT.ID_INSTITUTE=INSTITUTE.ID

It is related with another table of the DB

Key field of this table could be a field of relationship

It is not related with another table of the DB

It must contain at least one record

It must have a complex key

SELECT *

FROM EMPLOYEE E, EMPLOYEE M

WHERE E.ID = M.MANAGER_ID AND E.SALARY > M.SALARY

SELECT *

FROM EMPLOYEE E JOIN EMPLOYEE M

ON E.ID = M.MANAGER_ID

WHERE E.SALARY > M.SALARY

SELECT SALARY

FROM EMPLOYEE E FULL JOIN EMPLOYEE M

ON E.ID = M.MANAGER_ID

WHERE E.SALARY > M.SALARY

SELECT *

FROM EMPLOYEE

WHERE SALARY = MAX(SALARY)

SELECT *

FROM EMPLOYEE

HAVING SALARY = MAX(SALARY)