Answer to Question #39119 in Databases | SQL | Oracle | MS Access for PHang

Question #39119
i have a sql question, was wondering why my query does not work. Here is the question: A list of the contact details (names, postal address and phone number) of all of the providers who supplied equipment for more than one activity. here is the code i entered: Select phonenumber, line1, city, postcode, providername from phone, address, provider where phone.extbusinessid=address.extbusinessid=provider.extbusinessid and provider.providerid IN(Select providerid, count(providerid)from a_p_equipment group by providerid having count(providerid)>1) limit 0,30;
1
Expert's answer

Not answered

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

Comments

No comments. Be first!

Leave a comment

Ask Your question

LATEST TUTORIALS
New on Blog
APPROVED BY CLIENTS
paypal