Ist Lab 5

IST210 Lab 5. 7/19/09 1. Display the employee_id, last_name, subdivision_id and the name of the part (the name will come from the demo_department table) for all employees. You will gain department and employee. SELECT employee_id, last_name, name FROM demo_employee, demo_department WHERE demo_employee.department_id = demo_department.

department_id; employee_id last_name name --------------------------------------- --------------- -------------- 7369 SMITH question 7499 ALLEN SALES 7505 DOYLE SALES 7506 DENNIS SALES 7507 BAKER operations 7521 blanket SALES 7555 PETERS SALES 7557 SHAW SALES 7560 DUNCAN SALES 7564 LANGE SALES 7566 JONES look for 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 fisherman RESEARCH 7820 ROSS SALES 7839 KING ACCOUNTING 7844...If you want to bum a full essay, order it on our website: BestEss ayCheap.com

If you want to get a full essay, visit our page: cheap essay