right join example

SQL

SQL JOIN types: how I combine tables and check the result

Two tables, one JOIN and suddenly revenue doubles. Unfortunately, only in the report. Here is how I choose a join for the question and check that the result still represents the right things.

18 Jun 202314 min read