โ† Caterpillar questions

JOINS vs concatenation; WHERE vs HAVING

Filed under Caterpillar

The question

Basic SQL questions: differences between joins and concatenation, and between WHERE and HAVING.

No write-up yet. Related questions below have one.

Related Caterpillar questions

Collected from public candidate posts and coding forums. Updated Nov 2026.