Question: # 6 The HSP _ TRANSACTIONS table has one row for every transaction. If , and only if , a transaction is a refund to

#6 The HSP_TRANSACTIONS table has one row for every transaction. If, and only if, a transaction is a refund to a coverage, it identifies the coverage with the RFND_COVERAGE_ID column. Not all refunds are to coverages, and not all coverages are refunded.
Use the following query to answer the question below it:
SELECT *
FROM HSP_TRANSACTIONS
your SQL here > COVERAGE
ON HSP_TRANSACTIONS.RFND_COVERAGE_ID = COVERAGE.COVERAGE_ID
What should replace your SQL here > to return only refunds to coverages?
SELECT ONE OF THE FOLLOWING (1 PT)
A. LEFT OUTER JOIN
B. INNER JOIN
C. RIGHT OUTER JOIN
D. FULL OUTER JOIN
 #6 The HSP_TRANSACTIONS table has one row for every transaction. If,

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!