select p.parent_name,p.parent_address,p.parent_zip,c.info,s.info from microsite m,parent_company p,city_info c,state_info s where m.microsite_code = and m.parent_code=p.parent_code and s.state_code=p.parent_state_code and c.city_code= p.parent_city_code