3 ms·
These mental paradigms helped me a great deal: 1) Think in terms of excel spreadsheets. At each step in your SQL you are creating a set of data. Doesn't usua
by rsyring 8y ago
These mental paradigms helped me a great deal:
1) Think in terms of excel spreadsheets. At each step in your SQL you are creating a set of data. Doesn't usually matter how many rites it is, you just want the right columns.
2) Once you have a recordset, decide how the next recordset goes together. I would mentally visualize putting one worksheet next to the other and think through what columns I had to join together to get the rows I wanted.
3) Make sure you know what your first recordset should be. This is the base data that everything can be joined into. I refer to this as the domain of records.