BuslerLAB5

BuslerLAB5 - Chelsea Busler Lab#5 1 SELECT employee_id...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Chelsea Busler Lab #5 7/13/11 1. SELECT employee_id , last_name , name FROM [IST210-WC].dbo.demo_employee , [IST210-WC].dbo.demo_department WHERE demo_employee . department_id = demo_department . department_id ; employee_id last_name name --------------------------------------- --------------- -------------- 7369 SMITH RESEARCH 7499 ALLEN SALES 7505 DOYLE SALES 7506 DENNIS SALES 7507 BAKER OPERATIONS 7521 WARD SALES 7555 PETERS SALES 7557 SHAW SALES 7560 DUNCAN SALES 7564 LANGE SALES 7566 JONES RESEARCH 7569 ALBERTS RESEARCH 7600 PORTER SALES 7609 LEWIS OPERATIONS 7654 MARTIN SALES 7676 SOMMERS OPERATIONS 7698 BLAKE SALES 7782 CLARK ACCOUNTING 7788 SCOTT RESEARCH 7789 WEST SALES 7799 FISHER RESEARCH 7820 ROSS SALES 7839 KING ACCOUNTING 7844 TURNER SALES 7876 ADAMS RESEARCH 7900 JAMES SALES 7902 FORD RESEARCH 7916 ROBERTS RESEARCH 7919 DOUGLAS RESEARCH 7934 MILLER ACCOUNTING 7950 JENSEN SALES 7954 MURRAY SALES (32 row(s) affected) 2. SELECT
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 3

BuslerLAB5 - Chelsea Busler Lab#5 1 SELECT employee_id...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online