In This Chapter
Using SQL functions
Creating calculated fields
Working with date values
Creating inner joins and link tables
Single tables aren't sufficient for most data. If you understand the rules of data normalization (see Chapter 3 of this minibook), you know how to break your data into a series of smaller tables. The question remains, though: How do you recombine all these broken-up tables to make something the user can actually use?
In this chapter, you discover several techniques for combining the data in your tables to create useful results.