Delphi. 11



         

. - 3


COUNTRY CURRENCY

=============== ==========

USA Dollar

. :

SELECT currency FROM country

CURRENCY

==========

Dollar

Pound

CdnDlr

SFranc

Yen

Lira

FFranc

D-Mark

ADollar

HKDollar

Guilder

BFranc

Schilling

FDollar

, .. Restriction Projection. .

SELECT currency FROM country

WHERE country = Japan

CURRENCY

==========

Yen

SELECT first_name, last_name

FROM employee

WHERE first_name = "Roger"
,
Roger

FIRST_NAME LAST_NAME

=============== ====================

Roger De Souza

Roger Reeves

SELECT SQL ( ):

SELECT ()

FROM ()

WHERE ()

( ) .

SELECT first_name, last_name, proj_name

FROM employee, project

WHERE emp_no = team_leader