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. Regardi

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-different-types-of-joins 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.