First create a new query with the CompuPlants Gold database (see previous tuturial). This time however we will need to add fields from different tables as we would like to show the plant name alongside the catalog code. So browse down to "plants" and add "pltnme" (the plant name). From "orderd" add "prdperno" (the catalog code) and "curqty" (the quantity of a product in each order). Click the "Next" button and warning should show up asking you to join the two different tables. Select "Ok" to continue.

A new screen with the different tables should show up. First off we need to join the two tables together so the data matches up. So select "pltno" in the left table and drag it to the "pltno" on the right table. This is called a join.

Since we would like to have the totals of all items for each order added together we need to sum each individual "curqty" for each product. To do this select a cell under "curqty" and then press the summation button in the toolbar (one left of the AZ button).

To get the data into Excel goto the File menu and select "Return Data to Microsoft Excel"

Back to tutorials index