× Didn't find what you were looking for? Ask a question
Top Posters
Since Sunday
A
6
j
6
c
5
m
5
C
5
d
5
s
5
n
4
i
4
d
4
d
4
J
4
Home Q & A Board Other Fields Homework Help Business Management
New Topic  
dextersim97 dextersim97
wrote...
Go to Answer
6 years ago
Which of the following queries will display the first and last name of the individual who referred another customer, along with the customer of the referred customer?
 a. SELECT r.firstname, r.lastname, c.customerFROM customers r, customers cWHERE r.customer = c.referred;
  b. SELECT r.firstname, r.lastname, c.customerFROM customers r JOIN customers cON r.customer = c.referred;
  c. SELECT r.firstname, r.lastname, c.customerFROM customers r NATURAL JOIN customers c;
  d. both a and b
Read 26 times
1 Reply
Replies
Answer verified by a subject expert
Alphabet!Alphabet!
wrote...
#1
Top Poster
Posts: 920
Rep: 5 0
6 years ago
Sign in or Sign up in seconds to unlock everything for free
1

Related Topics

hannahspillett
wrote...

6 years ago
I appreciate what you did here, answered it right Smiling Face with Open Mouth
hmonier
wrote...

Yesterday
Good timing, thanks!
AlahuKakpar
wrote...

2 hours ago
Just got PERFECT on my quiz
New Topic      
Quick Reply
Explore
Post your homework questions and get free online help from our incredible volunteers
  888 People Browsing
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Live Chat
Related Images
  
 1748
  
 811
  
 634
Your Opinion
Who's your favorite biologist?
Votes: 587
Previous poll results: Do you trust social media networks with protecting your privacy?