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

Question

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;