🗄️ Databases & Backend

LeetCode's Sneaky SQL Trap: Why 'test.p' Isn't a Table — And the JOIN Twist That Bites

2.5 million solves on LeetCode #175, yet this SQL error still trips up devs daily. It's not you — it's the sneaky syntax of aliases and JOIN defaults.

DevTools Feed Apr 03, 2026 3 min read 10 views
Screenshot of MySQL error: Table 'test.p' doesn't exist from LeetCode query

⚡ Key Takeaways

  • SQL aliases go Table [space] alias — reverse it and parsers revolt. 𝕏
  • JOIN defaults to INNER; use LEFT JOIN for nulls on missing matches. 𝕏
  • LeetCode #175 reminds us: read specs, master syntax over speed. 𝕏
Published by

DevTools Feed

Ship faster. Build smarter.

#JOIN behavior #LeetCode 175 #MySQL errors #SQL aliases

Worth sharing?

Get the best Developer Tools stories of the week in your inbox — no noise, no spam.

Originally reported by dev.to

Related Stories

📬

Stay in the loop

The week's most important stories from DevTools Feed, delivered once a week.

No spam. Unsubscribe any time.