× Didn't find what you were looking for? Ask a question
Top Posters
Since Sunday
c
6
r
4
c
3
m
3
h
3
1
3
n
3
s
3
d
3
c
3
r
3
e
3
Home Q & A Board Other Fields Homework Help Business Management
New Topic  
kekule kekule
wrote...
Go to Answer
Posts: 687
Rep: 0 0
6 years ago
The query to join the P_DESCRIPT and P_PRICE fields from the PRODUCT table and the V_NAME, V_AREACODE, V_PHONE, and V_CONTACT fields from the VENDOR table where the values of V_CODE match is _____.
 a. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONEFROM PRODUCT, VENDORWHERE PRODUCT.V_CODE <> VENDOR.V_CODE;
 b. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONEFROM PRODUCT, VENDORWHERE PRODUCT.V_CODE = VENDOR.V_CODE;
 c. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONEFROM PRODUCT, VENDORWHERE PRODUCT.V_CODE <= VENDOR.V_CODE;
 d. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONEFROM PRODUCT, VENDORWHERE PRODUCT.V_CODE => VENDOR.V_CODE;
Read 32 times
1 Reply
Replies
Answer verified by a subject expert
shelbydickersonshelbydickerson
wrote...
#1
Top Poster
Posts: 860
Rep: 6 0
6 years ago
Sign in or Sign up in seconds to unlock everything for free
1

Related Topics

kekule Author
wrote...

6 years ago
Correct Slight Smile TY
Katey_maree
wrote...

Yesterday
Smart ... Thanks!
bbbbbbbh
wrote...

2 hours ago
Thanks for your help!!
New Topic      
Quick Reply
Explore
Post your homework questions and get free online help from our incredible volunteers
  1204 People Browsing
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Live Chat
Related Images
  
 292
  
 229
  
 724
Your Opinion
Who will win the 2024 president election?
Votes: 110
Closes: November 4
Previous poll results: Which industry do you think artificial intelligence (AI) will impact the most?