SELECT s.businessID, s.smallLogo, s.parentbusinessID, s.name, s.listingCity, s.listingState, s.featuredURL, s.featured, s.listingDesc, st.name AS stateName, s.zip AS zip FROM business s join state st on st.stateID = s.listingState, xbusinesscategorytype x, categorytype ct WHERE (s.featured = 'A' OR s.featured = 'B') AND s.listingState <> '' AND ((st.stateID = 'SK' AND s.listingState = st.stateID) OR (s.businessID IN (SELECT businessID from businessListingStates where stateID='SK' and businessID=s.businessID))) AND s.businessID = x.businessID AND x.categoryTypeID=ct.categoryTypeID AND ct.searchwithall = 'Y' ORDER BY st.name, s.featured, s.listingCity, s.name
All BeautySchools in SASKATCHEWAN, CANADA (alphabetized by city)
These schools also accept students from SASKATCHEWAN, CANADA (alphabetized by city name)
This is a 20,000 square foot facility that incorporates state of the art technology and training techniques to ensure graduates are given the best possible career... More Info...
