在对外部查询应用惟一筛选器时可使用类似的技术,点符号将用于说明筛选结果所依据的字段。
A similar technique is used when applying the unique filter to the outer query, with dot notation used to indicate the field by which results are to be filtered.
这段脚本的第一小段跟以前一样 — 两个嵌套的 SQL 查询,内部查询使用外部查询的数据生成一个国家和城市数据列表。
The first segment of this script is as before — two nested SQL queries, with the inner one using data from the outer one to generate a list of country and city data.
在清单11中,通过创建保存查询的外部文件使查询参数化。
In Listing 11, parameterize your query by creating an external file that holds your query.
应用推荐