Hacker News new | past | comments | ask | show | jobs | submit login

I mean, i think you just need practice. i feel like you're thinking too literally about the basic process of programming and trying to apply it to sql.

Regarding table joins, this visual with venn diagrams on https://stackoverflow.com/questions/17946221/sql-join-and-di... usually helps me. But again, it's just practice. Try to think of real world cases and then creating relevant join statements for those.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact