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

UptoLike

Составители: 

21
44) SELECT *
FROM titles t, publishers p
WHERE t.pub_id=p.pub_id
45) SELECT t.*, pub_name
FROM titles t, publishers p
WHERE t.pub_id=p.pub_id
46) SELECT a.city, a.state
FROM authors a, publishers p
WHERE a.city=p.city AND a.state=p.state
47) SELECT au_lname, au_fname
FROM authors a JOIN titleauthor ON a.au_id=ta.au_id
JOIN titles t ON ta.title_id=t.title_id
WHERE au_lname LIKE “R%”
AND state IN (“CA”, “TX”, “NY”, “OR”, “UT”)
AND (title LIKE “_h_ %” OR title LIKE “% _h_ %”
OR title LIKE “% _h_”)
48) SELECT title, type
FROM authors a, titles t, titleauthor ta, publishers p
WHERE ta.title_id=t.title_id AND a.au_id=ta.au_id
AND t.pub_id=p.pub_id AND p.city=a.city
49) SELECT au_lname, au_fname, title
FROM authors a, titles t, titleauthor ta, publishers p
WHERE ta.title_id=t.title_id AND a.au_id=ta.au_id
AND t.pub_id=p.pub_id
AND ((p.country= ‘USA’ AND t.type=’popular_comp’)
OR (p.country=’France’ AND t.type=’psychology’))
50) SELECT au_lname, au_fname, city
FROM authors a, titles t, titleauthor ta
WHERE ta.title_id=t.title_id AND a.au_id=ta.au_id
44) SELECT *
 FROM titles t, publishers p
 WHERE t.pub_id=p.pub_id

45) SELECT t.*, pub_name
 FROM titles t, publishers p
 WHERE t.pub_id=p.pub_id

46) SELECT a.city, a.state
 FROM authors a, publishers p
 WHERE a.city=p.city AND a.state=p.state

47) SELECT au_lname, au_fname
 FROM authors a JOIN titleauthor ON a.au_id=ta.au_id
      JOIN titles t ON ta.title_id=t.title_id
     WHERE au_lname LIKE “R%”
      AND state IN (“CA”, “TX”, “NY”, “OR”, “UT”)
      AND (title LIKE “_h_ %” OR title LIKE “% _h_ %”
           OR title LIKE “% _h_”)

48) SELECT title, type
 FROM authors a, titles t, titleauthor ta, publishers p
 WHERE ta.title_id=t.title_id AND a.au_id=ta.au_id
      AND t.pub_id=p.pub_id AND p.city=a.city

49) SELECT au_lname, au_fname, title
 FROM authors a, titles t, titleauthor ta, publishers p
 WHERE ta.title_id=t.title_id AND a.au_id=ta.au_id
      AND t.pub_id=p.pub_id
      AND ((p.country= ‘USA’ AND t.type=’popular_comp’)
           OR (p.country=’France’ AND t.type=’psychology’))

50) SELECT au_lname, au_fname, city
 FROM authors a, titles t, titleauthor ta
 WHERE ta.title_id=t.title_id AND a.au_id=ta.au_id



                            21