Подзапросы. Подзапросы в операторах модификации удаления и вставки

2 запрос
select title, price
from titles
where price = $6
1 запрос
select price
from titles
where title = "Чтиво"
Объеденный запрос
select title, price
from titles
where price =
(select price
from titles
where title = "Чтиво")
Простой подзапрос

Уровневый запрос
select au_lname, au_fname
from authors
where au_id in
(select au_id
from titleauthor
where title_id in
(select title_id
from titles
where type = "popular_child") )
соединение
select au_lname, au_fname
from authors, titles, titleauthor
where authors.au_id = titleauthor.au_id
and titles.title_id = titleauthor.title_id
and type = "popular_ child "
Несколько уровней вложенности

update titles
set price = price * 2
where pub_id in (select pub_id
from publishers
where pub_name = "ОдесаДрук")
Соединение
set price = price * 2
from titles, publishers
where titles.pub_id = publishers.pub_id
and pub_name = "ОдесаДрук"
delete salesdetail
where title_id in
(select title_id
from titles
where type = "business")
соединение
delete salesdetail
from salesdetail, titles
where salesdetail.title_id = titles.title_id
and type = "business"
Подзапросы в операторах модификации удаления и вставки

if exists (select title_id
from titles
where type = "business")
begin delete salesdetail
where title_id in
(select title_id
from titles
where type = "business")
end
Подзапросы в условных операторах

select au_lname, au_fname
from authors
where city =
(select city from publishers
where pub_name = "ОдесаДрук")
Подзапросы-выражения