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;
0
Expert's answer

Answer in progress...

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 the first!

Leave a comment

LATEST TUTORIALS
New on Blog
APPROVED BY CLIENTS