当时没有弄清的连接

SELECT     SG_SUPPLIER_QUOTE.P_ID, SG_PRODUCTION.P_YEAR

FROM         SG_SUPPLIER                                INNER JOIN

                  SG_SUPPLIER_QUOTE                            ON SG_SUPPLIER.S_ID = SG_SUPPLIER_QUOTE.S_ID

                   RIGHT OUTER JOIN

                      SG_PRODUCTION                     ON SG_SUPPLIER_QUOTE.P_ID = SG_PRODUCTION.P_ID

                    LEFT OUTER JOIN

                      SG_PRODUCTION_MONOPOLIZATION

                   INNER JOIN

                      SG_CUSTOMER                          ON SG_PRODUCTION_MONOPOLIZATION.C_ID = SG_CUSTOMER.C_ID


                    ON  SG_PRODUCTION.P_ID = SG_PRODUCTION_MONOPOLIZATION.P_ID               

                LEFT OUTER JOIN

                      SG_YEAR                                        ON SG_PRODUCTION.P_YEAR = SG_YEAR.Y_ID