如果包含该列的表尚未添加,则查询设计器将该表添加到查询中。
If the table containing that column has not already been added, the query Designer adds it to the query.
如果您处理多个表,则查询和视图设计器将检查每个搜索条件以确定正在进行的比较是否将导致联接。
If you are working with multiple tables, the Query and View Designer examines each search condition to determine whether the comparison you are making results in a join.
如果在“条件”窗格或“SQL”窗格中手动向聚合函数添加查询输出列,则查询和视图设计器不能自动从查询中移除其他输出列。
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.
如果查询和视图设计器无法选择匹配列,则必须提供列名。
If the Query and View Designer cannot choose a match, you must provide the column name.
因此,如果将列添加到查询输出中,则查询和视图设计器会自动将其添加到“SQL”窗格中语句的GROUPby子句中。
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子句中。
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.
应用推荐