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
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