Our Retailers select distinct state_abbrv from wool_retailers w,zip_states z where z.state_abbrv = w.state order by z.state_abbrv
Retailers

Shops that carry Wool in the Woods' Kits and Yarns

WHOLESALE INQUIRIES WELCOME


select w.address, w.ind, w.title, w.city, w.phoneno, w.webpage, w.zipcode, w.state,z.state_desc from wool_retailers w, zip_states z where state='#aitem#' and z.state_abbrv=w.state order by city,title
#aitem#  Outside USA 

#state_desc# Back To The Top

#title#
#address#
#trim(city)##iif(state is not "ZZ" and state is not "",DE(",  #state#"),DE(""))#   #zipcode#
 #phoneno#
#webpage#
Retailers


select w.address, w.ind, w.title, w.city, w.phoneno, w.webpage, w.zipcode, w.state from wool_retailers w order by state,city,title
Name City State
#title# #city# #state#