76 956
Assignments Done
98,7%
Successfully Done
In June 2019

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;
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

Submit
Privacy policy Terms and Conditions