UNION, stacking two results
Stack two query results with UNION and UNION ALL, see how that differs from a JOIN, and turn football fixtures into one row per team per match.
- The skill
- Combine two result sets into one list, and know when repeats must stay.
- You make
- A round preview, goal tallies and one team's season so far for a football league.
Premium lesson
£7.99 a month or £59 a year. Cancel any time.
Builds on 21 CTEs, naming the steps with WITH. Free to try: SQL Foundations and the playground.
Passed
You can now
Step 1 of 7
exercise_1.sql
You've reached the good stuff.
4 exercises in this lesson, checked as you type. Premium opens every lesson after Foundations, in all four courses.
SQLite