SELECT StringMap.Value,*

FROM StringMap

      INNER JOIN MetadataSchema.Entity

            ON StringMap.ObjectTypeCode = MetadataSchema.Entity.ObjectTypeCode

WHERE

StringMap.AttributeName Like 'address1_addresstypecode'

AND MetadataSchema.Entity.Name Like 'account'