In SQL Query Analyzer, the statement used to display employee names together with all of their
job dates and times would be which of the following?
A) Select employee. name, job. jobdate, job. timestart, job. timeend From employee Inner Join
job On employee.ssn = job.ssn
B) Select employee. name, job. jobdate, job. timestart, job. timeend From employee.ssn Inner
Join On job.ssn
C) Select employee.name, job.jobdate, job.timestart, job.timeend From employee, job Where
employee.ssn = job.jobid
D) Select employee. name, job. jobdate, job. timestart, job. timeend From employee Inner Join
job On employee = job
A
You might also like to view...
One factor that is not considered in determining the useful life of an intangible asset is
a. salvage value. b. provisions for renewal or extension. c. legal life.
If Ming was interested in capturing distribution metrics for her retail organization, which of the following might she consider?
A) customer complaints B) share of shelf C) effective reach D) trial rate E) market share