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;
Numbers and figures are an essential part of our world, necessary for almost everything we do every day. As important…
APPROVED BY CLIENTS
"assignmentexpert.com" is professional group of people in Math subjects! They did assignments in very high level of mathematical modelling in the best quality. Thanks a lot
Comments
Leave a comment