Which command is used to find all customers who have a loan, an account,or both?

Question

Which command is used to find all customers who have a loan, an account,or both?

account
ACCOUNT_NUMBER BRANCH_NAME BALANCE
--------------- -------------------------------------------------- ----------
A-101 Downtown, 1011 Springfield Ave 10500
A-215 Mianus, 2011 Lincoln Ave 10700
A-102 Perryridge, 3011 Washington Ave 10400
A-305 Round Hill, 4011 Frankin Ave 10350
A-201 Perryridge, 3011 Washington Ave 10900

loan
LOAN_NUMBER BRANCH_NAME AMOUNT
--------------- -------------------------------------------------- ----------
L-17 Downtown, 1011 Springfield Ave 1000
L-23 Redwood, 6011 Roosevelt Ave 2000
L-15 Perryridge, 3011 Washington Ave 1500
L-14 Downtown, 1011 Springfield Ave 1500
L-93 Mianus, 2011 Lincoln Ave 500
L-11 Round Hill, 4011 Frankin Ave 900

borrower
CUSTOMER_NAME LOAN_NUMBER
--------------- ---------------
Adams L-16
Curry L-93
Hayes L-15
Jackson L-14
Jones L-17
McBride L-20
Smith L-11
Smith L-21
Smith L-23
Williams L-17

Explanation / Answer

SELECT ACCOUNT_NUMBER FROM ACCOUNT

UNION

SELECT LOAN_NUMBER FROM LOAN;

SELECT LOAN_NUMBER FROM BORROWER

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.