The following table lists parts. Many parts are contained in another part, called an assembly, and tracked in the AssemblyID column. If a part is not contained in another part, the AssemblyID is NULL.

CREATE TABLE Part $($

PartID SMALLINT,

PartName VARCHAR$(30),$

AssemblyID SMALLINT,

PRIMARY KEY $($PartID$),$

FOREIGN KEY $($AssemblyID$)$ REFERENCES Part$($PartID$)$

$)$;

The following self$-$join selects one row for each part. Each row contains the names of the part and the assembly, if any, containing the part. What XXX completes the query?

SELECT P$.$PartName AS Part, A$.$PartName AS Assembly

FROM Part P

XXX;