So far, we've joined tables based on common columns having the same name, like id here.

Make sure to pick id, followed by id.