Excellent! Here is another keyword:
INTERSECT. Let's change our example a little bit:
WHERE Country = N'Germany'
WHERE Country = N'Germany';
UNION ALL), we've put
INTERSECT in there. What's the difference?
UNION gave you all the results from the first query plus the results from the second query.
INTERSECT, on the other hand, only shows the rows that belong to both tables.
In this case, we would get the years when Germany got a medal in cycling and speed skating at the same time.
The conditions here stay the same: the number of columns in both tables must be the same, and the data types of the columns must match.