Предыдущая страница реферата | 4  5  6  7  8  9  10  11  12  13  14 | Следующая страница реферата

 where pub_name like 'Binnet%' or pub_name like 'New Moon%'

union all select 2 as tag, -- второй подзапрос

  1 as parent,

  pubs.pub_name,

  pubs.city,

  fname,

  lname

 from employee as e, publishers as pubs

 where (pub_name like 'Binnet%' or pub_name like 'New Moon%')

   and pubs.pub_id = e.pub_id

 order by 'pubs!1!PubName', 'pubs!1!City',

 'employee!2!First_Name', 'employee!2!Last_Name'

 for xml explicit