In Oracle, the statement used to show all employees' social ...

[Kikoku]

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]

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)

[Kikoku]

Thanks for the timely response, appreciate it

[peter]

Wow, this really help