reports builder学习一

练习一（列表）





DEPARTMENTS.DEPARTMENT_ID,
DEPARTMENTS.DEPARTMENT_NAME,
DEPARTMENTS.MANAGER_ID,
DEPARTMENTS.LOCATION_ID
FROM
DEPARTMENTS






练习二 邮件标签



SELECT EMPLOYEES.FIRST_NAME,
EMPLOYEES.LAST_NAME,
LOCATIONS.CITY,
LOCATIONS.STREET_ADDRESS,
LOCATIONS.POSTAL_CODE,
LOCATIONS.STATE_PROVINCE
FROM EMPLOYEES
INNER JOIN DEPARTMENTS
ON DEPARTMENTS.DEPARTMENT_ID = EMPLOYEES.DEPARTMENT_ID
AND EMPLOYEES.EMPLOYEE_ID = DEPARTMENTS.MANAGER_ID
INNER JOIN LOCATIONS
ON LOCATIONS.LOCATION_ID = DEPARTMENTS.LOCATION_ID