Advanced SQL Techniques: Streamline Queries

摘要

If I've said it once, I've said it a. thousand times: The Access Query Designer is fantastic and I - and many other professional developers - use it when creating queries. You can drag-and-drop fields onto the design grid and choose how to sort from a drop-down, all without remembering any table or field names. Even though I love the designer, I find it extremely useful to know the SQL created behind the scenes. During the course of development, I probably write SQL for half the queries I create.