急！！！如何将查询结果保存啊？

[palm99]

我才用select查询后，结果为什么保存不了啊？谁知道怎么保存？谢谢。

[ljydomybest]

slect等查询只是临时信息表，需用语句生成数据，表，文件保存！

[ljydomybest]

创建表会吧／

[dfwxj]

sele ....... into dbf 你想在保存的表

[TERRYYRRET]

select 字段名 from 表名 TO FILE FileName（into dbf 你保存的表）

[zhaounfi]

可以直接保存的吧！

[zhaounfi]

select选出后，用文件>导出，OK！

[Foxer]

常用的两种方法：

1. SELECT xxx INTO TABLE <TableName>
2. SELECT xxx INTO CURSOR <CursorName>
COPY TO <TableName>

[dfwxj]

SELECT [ALL | DISTINCT] [TOP nExpr [PERCENT]]
[Alias.] Select_Item [AS Column_Name]
[, [Alias.] Select_Item [AS Column_Name] ...]

FROM [FORCE]
[DatabaseName!]Table [[AS] Local_Alias]
[[INNER | LEFT [OUTER] | RIGHT [OUTER] | FULL [OUTER] JOIN
DatabaseName!]Table [[AS] Local_Alias]
[ON JoinCondition …]

[[INTO Destination]
| [TO FILE FileName [ADDITIVE] | TO PRINTER [PROMPT]
| TO SCREEN]]

[PREFERENCE PreferenceName]

[NOCONSOLE]

[PLAIN]

[NOWAIT]

[WHERE JoinCondition [AND JoinCondition ...]
[AND | OR FilterCondition [AND | OR FilterCondition ...]]]

[GROUP BY GroupColumn [, GroupColumn ...]]

[HAVING FilterCondition]

[UNION [ALL] SELECT命令]

[ORDER BY Order_Item [ASC | DESC] [, Order_Item [ASC | DESC] ...]]

[everyday1212]

收了
谢谢