Create a report that displays departments where Sales Repres

Create a report that displays departments where Sales Representatives (SA_REP) or IT Programmers (IT_PROG) work. Include the department number, department name, and location in the output. Hint: Use a subquery. Do not use any joins

Solution

Note:here sales ,ITprogrammer are table names.and work colum denotes designation

(SELECT department number,department name,location From Sales
WHERE work=\'SA_REP\')UNION ALL(SELECT department number,department name,location From ITprogrammer
WHERE work=\'IT_PROG\');