join

SELECT * FROM Employee, Departament

SELECT * FROM Organization CROSS JOIN Employee

------

SELECT * FROM Employee, Departament
WHERE Employee.departamentId = Departament.departamentId

SELECT * FROM Agreement
INNER JOIN Organization ON Organization.organizationId = Agreement.organizationId

-------

SELECT * FROM Agreement
INNER JOIN Organization ON Organization.organizationId = Agreement.organizationId
WHERE typeOfActivity = 'Банк'

SELECT * FROM DesignWork
INNER JOIN Departament ON Departament.departamentId = DesignWork.departamentId
WHERE departamentName LIKE '% % %'

-------

SELECT * FROM DesignWork
INNER JOIN Departament ON Departament.departamentId = DesignWork.departamentId
INNER JOIN Agreement ON Agreement.agreementId = DesignWork.agreementId



-------

SELECT * FROM Employee
FULL JOIN Departament ON Departament.departamentId = Employee.departamentId

SELECT * FROM Agreement
FULL JOIN Organization ON Organization.organizationId = Agreement.organizationId

--------

SELECT * FROM Employee
LEFT JOIN Departament ON Departament.departamentId = Employee.departamentId

SELECT * FROM Agreement
LEFT JOIN Organization ON Organization.organizationId = Agreement.organizationId

--------

SELECT * FROM Departament
RIGHT JOIN Employee ON Departament.departamentId = Employee.departamentId

SELECT * FROM Agreement
RIGHT JOIN Organization ON Organization.organizationId = Agreement.organizationId

=========

SELECT em1.*
FROM Employee em1, Employee em2
WHERE em2.name LIKE '%Селявко%' AND em2.address = em1.address AND NOT em1.name LIKE '%Селявко%'

SELECT agr1.*
FROM Agreement agr1, Agreement agr2
WHERE agr2.agreementNumber = 'BGP12221' AND agr2.date = agr1.date AND NOT agr1.agreementNumber = 'BGP12221'