I am in a SQL class for the University of Phoenix Oniline. I have an assignment in which I have to query a database and use UNION to create a new table with three columns(name, job title, salary. I have two table in the DB
EmployyeInfo: (ssn,last_name, first_name, job_title_code, address, city, state, postal_code, country, home_phone, work_phone, date_hired, salary, email_address)
JobTitleInfo: (job_title_code, job_title, exemption_status, min_salary, max_salary)
This is the query I wrote. I have to use UNION. Please someone tell me what I am doing wrong.