Let's start off with a new keyword:
UNION. What is a union? Well, long story short, it combines the results of two or more queries. Let's analyze the example:
WHERE Country = N'Germany'
WHERE Country = N'Germany';
As you can see, we first selected all medals for Germany from the
Cycling table. Then, we used the
UNION keyword, after which we selected all medals for Germany from the
You may be wondering whether we could've split this instruction into two separate queries. Of course we could have! But using a
UNION, we get all results for the first table plus the results of the second table shown together. Remember to only put the semicolon (
;) at the very end of the whole instruction!