Author Question: In Oracle, the statement used to show all employees' social security numbers and names that don't ... (Read 37 times)

Kikoku · **on:** Jul 7, 2018

In Oracle, the statement used to show all employees' social security numbers and names
that don't have jobs assigned to them, would be __________.

Fill in the blanks with correct word

Question 2

In Oracle, the statement used to show all clients' emails and contacts for whom jobs
have been done, would be __________.

Fill in the blanks with correct word

olderstudent · **Reply #1 on:** Jul 7, 2018

Answer to Question 1

Select employee.ssn, employee.name From employee Where employee.ssn Not In (Select Distinct job.ssn From job)

Answer to Question 2

Select client.email, client.contact From client Where client.email In (Select Distinct client.email From job)