We’re almost ready to dive into advanced SQL features. In Part I we built a solid foundation for SQL programming. Before we start using advanced features, we need to discuss how to construct our SQL statements.
The best way to write SQL statements is to create nested sets using inline views and the ANSI join syntax. First, we need to discuss common SQL problems – spaghetti code caused by the old join syntax and too much context. Sets, chunking, and functional programming can help us create simpler queries. We will combine those three concepts and implement them with inline ...
