× Didn't find what you were looking for? Ask a question
Top Posters
Since Sunday
g
3
3
2
J
2
p
2
m
2
h
2
s
2
r
2
d
2
l
2
a
2
New Topic  
kinglazy kinglazy
wrote...
Posts: 694
Rep: 0 0
6 years ago
Which of the following queries will return the same results as the following SQL statement? SELECT c.customer, lastname, firstname, order FROM customers c, orders o WHERE c.customer = o.customer;
 a. SELECT customer, lastname, firstname, orderFROM customers NATURAL JOIN orders;
  b. SELECT customer, lastname, firstname, orderFROM customers JOIN orders USING (customer);
  c. SELECT c.customer, lastname, firstname, orderFROM customers c, orders o;
  d. both a and b
Read 33 times
2 Replies
Replies
Answer verified by a subject expert
19leekichang19leekichang
wrote...
Top Poster
Posts: 913
6 years ago
Sign in or Sign up in seconds to unlock everything for free
1

Related Topics

kinglazy Author
wrote...
6 years ago
Passing because of you
New Topic      
Explore
Post your homework questions and get free online help from our incredible volunteers
  791 People Browsing
 122 Signed Up Today
Related Images
  
 1012
  
 159
  
 33
Your Opinion
Which industry do you think artificial intelligence (AI) will impact the most?
Votes: 352

Previous poll results: What's your favorite math subject?