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.
13 lines
227 B
13 lines
227 B
3 years ago
|
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
|