$4\mathrm{.}5\mathrm{.}1$: Inner and outer joins.

$546386\mathrm{.}3959570.$qx$3$zqy$7$

SELECT

FROM Order, Part

WHEREComplete the SQL statement to generate the Result table.

OrderCode PartName

A$36$ Wingding

Z$23$ Buzzer

$*/$Type your code here $*/$

$*/$Type your code here $*/$

Part

$$PartNumber PartName

$492$ Buzzer

$827$ Left wizard

$662$ Wingding

Order

$$OrderCode $$PartNumber

A$36662$

Z$23492$

Result;