CREATE OR REPLACE VIEW view_8 AS


    SELECT  g.*

    FROM    goods g, collection cl

    WHERE   g.g_collection = cl.cl_name   AND

            cl.cl_name     = 'Весна-лето' OR

            cl.cl_name     = 'Лето-осень' OR

            cl.cl_name     = 'Осень-зима' OR

            cl.cl_name     = 'Зима-весна'

;