Delphi. 11



         

. - 4


FIRST_NAME LAST_NAME PROJ_NAME

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

Ashok Ramanathan Video Database

Pete Fisher DigiPizza

Chris Papadopoulos AutoMap

Bruce Young MapBrowser port

Mary S. MacDonald Marketing project 3

. , UNION SQL- .

SELECT first_name, last_name, job_country

FROM employee

WHERE job_country = "France"

UNION

SELECT contact_first, contact_last, country

FROM customer

WHERE country = "France"
,

FIRST_NAME LAST_NAME JOB_COUNTRY

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

Jacques Glon France

Michelle Roche France

, SELECT, :

SELECT [DISTINCT] __ ()

FROM _ ( )

[WHERE ]

[GROUP BY ( ) [HAVING ]]

[UNION __Select]

[ORDER BY ( ) ()];

Ðèñ. 2: Îáùèé ôîðìàò êîìàíäû SELECT

, (), . . . , WISQL TQuery . , , - .

SQL , , , .