If the table containing that column has not already been added, the query Designer adds it to the query.
如果包含该列的表尚未添加，则查询设计器将该表添加到查询中。
Through Domino Designer, you can define a Domino view, the result set of which is based on an SQL query statement.
通过DominoDesigner，可以定义Domino视图，视图的结果集是根据一个SQL查询语句得到的。
The designer also generates a Fill query, which wraps the table's SELECT statement and is implemented as a method of the same name on the typed DataSet.
设计器同时也产生一个填充查询，它封装了查询相关表的Select语句并且在类型化数据集中以同名方法实现。
The typed DataSet designer accommodates by allowing you to add your own queries from the appropriate table's context menu by selecting add | Query from the table's context menu.
类型化数据集设计器允许你添加自己的查询语句，通过在适当表格的上下文菜单中选择“添加”|“查询”来实现。
After the view is saved, you can distinguish SQL Query Views by the grey and blue icon that appears to the left of the view name in Domino Designer (see figure 10).
保存视图后，可以通过在DominoDesigner中视图名称左侧显示的灰色和蓝色图标来区分SQL查询视图(参见图10)。
When you edit the SQL Query View in Domino Designer, a new event, SQL Query, appears in the programmer's pane, as shown in figure 11.
当在DominoDesigner中编辑SQL查询视图时，一个新的事件(SQLQuery)将出现在编程窗格中，如图11所示。
The Query and View Designer will not display data columns for a table or table-valued object if you do not have sufficient access rights to it or if the provider cannot return information about it.
如果您对表或表值对象没有足够的访问权限，或者提供程序无法返回有关它的信息，那么查询和视图设计器将不显示该表或表值对象的数据列。
The Query and View Designer automatically assigns a column alias to the column you are summarizing.
“查询及视图设计器”将自动为要汇总的列分配列别名。
The Query and View Designer can help you create and maintain the data retrieval and data manipulation portions of your application.
可以协助您建立与维护应用程式的资料撷取和资料操作部分。
When you add a column to search to the Criteria pane, the Query and View Designer also adds it to the list of columns to copy.
当向“条件”窗格添加要搜索的列时，查询和视图设计器也会将该列添加到要复制的列的列表中。
Typically when you open a view or create a new query all four Windows open, but if you need to open any of these Windows, you can do so as long as the query and view Designer is open.
通常，当您打开一个视图或者创建一个新查询时，所有四个窗口都会打开，但是如果您需要打开其中的任何窗口，只要查询和视图设计器是打开的，就可以打开特定的窗口。
Describes the query types you can use with the query and View Designer.
描述可以搭配[查询和检视表设计工具]使用的查询类型。
Open a view or create a new query to open the query and view Designer.
打开一个视图或创建一个新查询以打开查询和视图设计器。
If they are, the Query and View Designer automatically puts join lines between the rectangles representing the tables or table-structured objects.
如果相关，查询和视图设计器自动在表示表或表结构对象的矩形之间添加联接线。
However, the query and View Designer will not prevent you from choosing an option that can result in a query that will not run.
然而，查询和视图设计器不会防止您选择可能产生无法运行的查询的选项。
This paper has a discussion on the process of information management design to use the common property of Database tools, query designer, class design, SQL language in the process of program design.
论述了在程序设计过程中，使用数据库开发工具独有的字段通用属性、查询设计器、类设计及SQL语言等功能，完成信息管理系统的设计过程。
Understanding how and and OR clauses are related when combined can help you construct and understand complex queries in the Query and View Designer.
了解组合AND和OR子句时它们的相关方式将有助于构造和理解查询和视图设计器中的复杂查询。
If you manually add a query output column to an aggregate function in either the Criteria or SQL pane, the query and View Designer does not automatically remove other output columns from the query.
如果在“条件”窗格或“SQL”窗格中手动向聚合函数添加查询输出列，则查询和视图设计器不能自动从查询中移除其他输出列。
When you enter data using local-specific format in the Criteria pane, the Query and View Designer automatically translates it to ANSI format in the SQL pane.
当在“条件”窗格中以特定于本地的格式输入数据时，查询和视图设计器在“SQL”窗格中会自动将其转换为ANSI 格式。
Introduce a way to merge several system controls into a custom control with class designer by the example of implementing record Pointers locating and query function.
以数据记录指针的定位及查询功能的实现为例，详细介绍了使用类设计器将系统控件组合成用户定义控件的方法。
Therefore, if you add columns to the query output, the query and View Designer automatically adds them to the GROUP BY clause of the statement in the SQL pane.
因此，如果将列添加到查询输出中，则查询和视图设计器会自动将其添加到“SQL”窗格中语句的GROUPby子句中。
The query and view Designer opens when you open the definition of a view, show the results for a query or view, or create or open a query.
当您打开视图的定义，显示查询或视图的结果或者创建或打开查询时，查询和视图设计器将打开。
Modify the SQL statement created by the Query and View Designer based on Settings you make in the Diagram and Criteria panes.
根据您在[图表]和[准则]窗格所做的设定，修改由[查询和检视表设计工具]建立的SQL陈述式。
The Query and View Designer does not check whether the name is already in use or whether you have permission to create the table.
查询和视图设计器不检查该名称是否已被使用，也不检查您是否有创建表的权限。
In the query and View Designer, the pane shows the results of the most recently executed Select query.
在[查询和检视表设计工具]中，该窗格显示的是最近执行选取查询的结果。
If you use more than one mathematical operator in an expression, the Query and View Designer processes the expression according to the following operator precedence.
如果一个运算式中使用多个算术运算子，查询和检视表设计工具会依照以下的运算子优先顺序处理运算式。
If you enter an SQL statement, but then make further changes to the query by changing the Diagram and Criteria panes, the query and View Designer rebuilds and redisplays the SQL statement.
如果您输入SQL陈述式，然后又变更[图表]和[准则]窗格来进一步变更查询，[查询和检视表设计工具]将重新建置并重新显示SQL陈述式。
In the Query and View Designer, be sure the Diagram pane is visible.
在查询和检视表设计工具中，确定[图表]窗格是可见的。
In addition, the Query and View Designer creates a join line between the two occurrences of the table or table-valued object within the Diagram pane.
此外，[查询和检视表设计工具]会在[图表]窗格的两个资料表或资料表值物件之间建立联结线。
Like View Designer, Query Designer has four panes: the Diagram pane, the Criteria pane, the SQL pane, and the Results pane.
如同[检视表设计工具]，[查询设计工具]有四个窗格：[图表]窗格、[准则]窗格、[SQL]窗格和[结果]窗格。
应用推荐