Delphi. 11



         


, , true. .

,

SELECT first_name, last_name, department

FROM employee e, department d

WHERE e.dept_no = d.dept_no

, (e.dept_no = d.dept_no) true.

, true. , (.. false), null .

: LEFT JOINRIGHT JOIN.

(LEFT JOIN) (.. , LEFT JOIN) , . , , null.

- .

SELECT first_name, last_name, department

FROM employee e LEFT JOIN department d

ON e.dept_no = d.dept_no

,
,

FIRST_NAME LAST_NAME DEPARTMENT

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

Robert Nelson Engineering

Bruce Young Software Development

Kim Lambert Field Office: East Coast

Leslie Johnson Marketing