我使用的软件将只允许我进入的地方.SQL语句的部分。然而,SELECT DISTINCT Left([PR].[WBS1],5)&"-000" AS WBS1GROUP BY Left([PR].[WBS1],5), Right([PR].[WBS1],3), PR.Status
HAVING ((Right(PR.WBS1,3)<>
/-cityname/result,9-10 (digits may be any numbers from 1 to N)example.com/vm-search/level1category/level2category-citynameexample.comlevel2category/level3category-cityn