"Table 'test.p' doesn't exist" — Understanding SQL Aliases and Default JOIN Behavior

While solving the LeetCode #175 (Combine Two Tables) problem, I encountered a couple of unexpected...