In Microsoft Access, the statement used to display employees' social security numbers and
names that don't have any jobs assigned to them, would be which of the following?
A) Select Employee.SSN, Employee.Name From Job Where Employee.SSN Not In (Select
Distinct Job.SSN From Job)
B) Select Employee.SSN, Employee.Name From Employee Where Employee.SSN Not In
(Select Distinct Job.SSN From Job)
C) Select Employee.SSN, Employee.Name From Employee Where Employee.SSN In (Select
Distinct Job.SSN From Job)
D) Select Employee.SSN, Employee.Name From Job Where Employee.SSN Not In (Select
Distinct Employee.SSN From Employee)
D
You might also like to view...
A restaurant manager tracks complaints from the diner satisfaction cards that are turned in at each table. The data collected from the past week's diners have been plotted and appear in the following graph
The number of complaints for each category is with each bar. How was the value for the point represented by the triangle calculated? A) B) C) D)
An express warranty must be in writing
Indicate whether the statement is true or false