Superbly explained Jeff. I must say that I am very naive when it comes to database programming since I am an applications and networking programmer primarily and as such, have a tendency to view databases as a big black box of data, nothing more…
I liked your usage of Venn Diagrams, it helped me see joins in a completely different light, I was very narrow minded.
That being said, could Venn Diagrams be applied to three or more table join statements? I find myself running into some problems recently in my rather inferior SQL statements hence the question.
Once again, great work, really enjoy reading your posts.