Game-Set-Match/joins.sql at main · patch72/Game-Set-Match · GitHub

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
-- tab = inner join
select h.*
      ,c.color
  from hand h
  join colors c on (c.color = h.color);
-- tab = left outer join
select h.*
      ,c.color
  from hand h
  left outer join colors c on (c.color = h.color);
-- tab = right outer join
select h.*
      ,c.color
  from hand h
 right outer join colors c on (c.color = h.color);
-- tab = full outer join
select h.*
      ,c.color
  from hand h
  full outer join colors c on (c.color = h.color);
-- tab = left anti join
select h.*
      ,c.color
  from hand h
  left outer join colors c on (c.color = h.color)
 where c.color is null;
-- tab = right anti join
select h.*
      ,c.color
  from hand h
 right outer join colors c on (c.color = h.color)
 where h.color is null;
-- tab = full outer join
select h.*g
      ,c.color
  from hand h
  full outer join colors c on (c.color = h.color)
 where c.color is null
    or h.color is null;