Share this Page URL

Chapter 6. Sorting, Filtering, and Retri... > Designing Select Queries - Pg. 208

Sorting, Filtering, and Retrieving Data 208 3. 4. In the Show Table dialog box, select the table or tables you want to add to the query. For this example, select MarketingCampaigns, click Add, and then click Close. In the field list for the MarketingCampaigns table at the top of the window, click CampaignID, and then drag it to the Field row in the first column. Repeat this step to add Country, Launch- Date, and CampaignBudget to the second, third, and fourth columns. (You can also double- click a field in the field list to add it to the first blank column in the query design grid.) The Query Design window should look like the following: