!

"#

$ %& '

()

!

* (

+

, ,

-(

.

- . ( , .

/ 0 (

1., (

-

2 ( (

3 4* (

1., (

+5+ 0 ( 0 +

6,

-

2)( -

- 7

(8

.

1., (

2.

+

5. 0 + 9

2 . (

(

(

1., (

#

(( * ( 63-

* ( 7

1., (

2.

+

+ 9

2 ,

.

(

,

0

1.

(

1., (

:

;

* ( <

,, , (

1., (

#

((

* (

, =

(

0

1. >

9

,2)(

5

1., ( , (5 ,(

(( 6? 4 ;

* ( 7

9

(( 6@

;

* ( 7

(

6A

;

* ( 7

( 0 (

1., ( ,

. 0

1.

, 9

2

(

0

1

(

(

3 - 0 (

1., ( ,

(

- B#

3C3

C

* (

8 1., ( ( 2 ( D.

8 1., (

2.

.0,

-

1., (

(( - () 2 ( DE

F

!

"

3

(

. .,

SELECT dname, ename

FROM Dept D, EMP E
WHERE E.deptno=D.deptno AND
LOWER(loc) LIKE '%ll%';

3

(

!3#

SELECT ( - 9 ( -
FROM Dept D NATURAL JOIN Emp E
WHERE LOWER(loc) LIKE '%ll%';

G

# $%

Składnia dotychczasowa

SELECT D.dname, D.loc || ' ' || E.ename

Name, E.hiredate

FROM Emp E, Dept D
WHERE E.deptno = D.deptno
AND job = ‘SALESMAN';

H

JOIN

Składnia ANSI

SELECT D.dname, D.loc || ' ' || E.ename,

E.hiredate

FROM Emp E JOIN Dept D USING(depno)
WHERE E.job = ‘SALESMAN';

&

I

Poł czenie INNER JOIN ... ON

Składnia ANSI

SELECT D.dname, E.ename
FROM Emp E
INNER JOIN Dept D ON
(E.depno = D.deptno)
WHERE E.job = ‘S%’;