SQL> SELECT p1.pname, p2.pname
FROM parts p1
JOIN parts p2
        ON (p1.pname != p2.pname)
ORDER BY p1.pname;

PNAME                          PNAME
------------------------------ ------------------------------
Dirty Harry                    Land Before TIME I
Dirty Harry                    Land Before TIME II
Dirty Harry                    Land Before TIME IV
Dirty Harry                    WHEN Harry Met Sally
Dirty Harry                    Dr. Zhivago
Dirty Harry                    Sleeping Beauty
Dirty Harry                    Land Before TIME III
Dr. Zhivago                    Land Before TIME I
Dr. Zhivago                    Dirty Harry
Dr. Zhivago                    Land Before TIME II
Dr. Zhivago                    Land Before TIME III

PNAME                          PNAME
------------------------------ ------------------------------
Dr. Zhivago                    WHEN Harry Met Sally
Dr. Zhivago                    Sleeping Beauty
Dr. Zhivago                    Land Before TIME IV
Land Before TIME I             Land Before TIME II
Land Before TIME I             Dr. Zhivago
Land Before TIME I             Dirty Harry
Land Before TIME I             WHEN Harry Met Sally
Land Before TIME I             Land Before TIME III
Land Before TIME I             Sleeping Beauty
Land Before TIME I             Land Before TIME IV
Land Before TIME II            Land Before TIME I

PNAME                          PNAME
------------------------------ ------------------------------
Land Before TIME II            Land Before TIME III
Land Before TIME II            Sleeping Beauty
Land Before TIME II            Dirty Harry
Land Before TIME II            Dr. Zhivago
Land Before TIME II            WHEN Harry Met Sally
Land Before TIME II            Land Before TIME IV
Land Before TIME III           Land Before TIME I
Land Before TIME III           Dr. Zhivago
Land Before TIME III           Dirty Harry
Land Before TIME III           WHEN Harry Met Sally
Land Before TIME III           Sleeping Beauty

PNAME                          PNAME
------------------------------ ------------------------------
Land Before TIME III           Land Before TIME IV
Land Before TIME III           Land Before TIME II
Land Before TIME IV            Land Before TIME I
Land Before TIME IV            Land Before TIME III
Land Before TIME IV            Sleeping Beauty
Land Before TIME IV            Dirty Harry
Land Before TIME IV            Dr. Zhivago
Land Before TIME IV            WHEN Harry Met Sally
Land Before TIME IV            Land Before TIME II
Sleeping Beauty                Land Before TIME I
Sleeping Beauty                Dr. Zhivago

PNAME                          PNAME
------------------------------ ------------------------------
Sleeping Beauty                Dirty Harry
Sleeping Beauty                WHEN Harry Met Sally
Sleeping Beauty                Land Before TIME IV
Sleeping Beauty                Land Before TIME II
Sleeping Beauty                Land Before TIME III
WHEN Harry Met Sally           Land Before TIME I
WHEN Harry Met Sally           Sleeping Beauty
WHEN Harry Met Sally           Land Before TIME IV
WHEN Harry Met Sally           Dirty Harry
WHEN Harry Met Sally           Dr. Zhivago
WHEN Harry Met Sally           Land Before TIME III

PNAME                          PNAME
------------------------------ ------------------------------
WHEN Harry Met Sally           Land Before TIME II