-
Notifications
You must be signed in to change notification settings - Fork 0
/
combining-queries.sql
46 lines (40 loc) · 1.61 KB
/
combining-queries.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
-- UNION
SELECT * FROM ab2018.tb_uye_hareketleri uh WHERE uh.uye_id = 15
UNION
SELECT * FROM ab2018.tb_uye_hareketleri uh WHERE uh.uye_id = 32;
-- UNION ALL
SELECT u.ad, u.soyad, k.yazar, k.kitap_adi FROM ab2018.tb_uye_hareketleri uh
JOIN genel.tb_uyeler u ON u.id = uh.uye_id
JOIN genel.tb_kitaplar k ON k.id = uh.kitap_id
WHERE uh.uye_id = 3 AND
uh.tarih BETWEEN '2015-01-01' AND '2015-12-31'
UNION ALL
SELECT u.ad, u.soyad, k.yazar, k.kitap_adi FROM ab2018.tb_uye_hareketleri uh
JOIN genel.tb_uyeler u ON u.id = uh.uye_id
JOIN genel.tb_kitaplar k ON k.id = uh.kitap_id
WHERE uh.uye_id = 7 AND
uh.tarih BETWEEN '2015-01-01' AND '2015-12-31';
-- INTERSECT
SELECT u.ad, u.soyad, k.yazar, k.kitap_adi FROM ab2018.tb_uye_hareketleri uh
JOIN genel.tb_uyeler u ON u.id = uh.uye_id
JOIN genel.tb_kitaplar k ON k.id = uh.kitap_id
WHERE uh.uye_id = 3 AND
uh.tarih BETWEEN '2015-01-01' AND '2015-12-31'
INTERSECT
SELECT u.ad, u.soyad, k.yazar, k.kitap_adi FROM ab2018.tb_uye_hareketleri uh
JOIN genel.tb_uyeler u ON u.id = uh.uye_id
JOIN genel.tb_kitaplar k ON k.id = uh.kitap_id
WHERE uh.uye_id = 7 AND
uh.tarih BETWEEN '2015-01-01' AND '2015-12-31';
-- EXCEPT
SELECT u.ad, u.soyad, k.yazar, k.kitap_adi FROM ab2018.tb_uye_hareketleri uh
JOIN genel.tb_uyeler u ON u.id = uh.uye_id
JOIN genel.tb_kitaplar k ON k.id = uh.kitap_id
WHERE uh.uye_id = 3 AND
uh.tarih BETWEEN '2015-01-01' AND '2015-12-31'
EXCEPT
SELECT u.ad, u.soyad, k.yazar, k.kitap_adi FROM ab2018.tb_uye_hareketleri uh
JOIN genel.tb_uyeler u ON u.id = uh.uye_id
JOIN genel.tb_kitaplar k ON k.id = uh.kitap_id
WHERE uh.uye_id = 7 AND
uh.tarih BETWEEN '2015-01-01' AND '2015-12-31';