Работа с базами данных в архитектуре клиент-сервер. Дубинин В.Н. - 31 стр.

      FROM titles t2
      WHERE t2.pub_id=p1.pub_id
          AND EXISTS
                 (SELECT *
                 FROM titleauthor ta3, authors a3
                 WHERE ta3.au_id=a3.au_id
                      AND ta3.title_id=t2.title_id
                      AND a3.state IN
                            (SELECT state
                            FROM publishers p4
                            WHERE “business”=SOME
                                  (SELECT type
                                  FROM titles t5
                                  WHERE p4.pub_id=
                                        t5.pub_id))))

92) SELECT city, state
 FROM authors
 UNION SELECT city, state
        FROM publishers
        ORDER BY state, sity

93) SELECT city
 FROM authors
 UNION SELECT city
        FROM publishers

94) SELECT state
 FROM authors
 UNION SELECT state
        FROM publishers

95) SELECT city, state
 FROM authors
 WHERE state IS NOT NULL
 UNION SELECT city, state



                          31