back to the basics – SQL
Every now and then its a good idea for even an experienced developer to revisit the basics again. SQL joins esp complicated ones weren’t exactly my strong point anyway, and today was a good day to get back to some basics… I found this site particularly good because of the explanation wrt the set theory (which as Murali had remarked was what relational databases are really all about) using Venn diagrams.
Getting the Right Data with SQL Joins
Associating tables in SQL is usually a breeze. But what happens when you find yourself looking at the completely wrong set of records and you don’t know why? Find out how correctly applying joins can help you understand and avoid these mysterious data returns.
Sometimes, getting back to basics does help, indeed.