select d.domainName from fsenablers..tbl_CUS_Websites w inner join fsenablers..tbl_CUS_WebsiteDomains d on d.websiteId = w.websiteId where portal_ownerId = and portal_ownerType = insert into tbl_SSO_Providers ( domainOwnerId, domainOwnerType, provider, providerRole, sharedSecret, samlversion, comment ) values ( , , , 'SERVICE', 'Concerned About Chinese Shrimp?', 1.0, '1FS Front Door' )