You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
|
USE Study
|
|
GO
|
|
|
|
SELECT * FROM EMPLOYEE
|
|
SELECT * FROM DEPARTMENT
|
|
|
|
SELECT *
|
|
FROM EMPLOYEE, DEPARTMENT
|
|
WHERE ENO = 103 AND EMPLOYEE.DNO = DEPARTMENT.DNO
|
|
|
|
SELECT *
|
|
FROM EMPLOYEE AS E, DEPARTMENT AS D
|
|
WHERE ENO = 103 AND E.DNO = D.DNO |
