A data architect wants to combine data on presentand historic sales performance.The historic data is stored in a de-normalized archive, and the present data is maintained in a database. The output must be contained in a single table.

Which script should the data architect use?

A)

B)

C)

D)