Visual FoxPro 中的 SQL Select 查询 基本的 SQL Select.................................................................................................................................. 2 From 子句 ........................................................................................................................................ 2 Select 子句 ...................................................................................................................................... 2 SQL 和用户自定义函数 ................................................................................................................... 2 Select 子句中的关键字和其它子句 .................................................................................................. 3 Select 子句中的通配符 ............................................................................................................. 3 字段别名(AS) ............................................................................................................................ 3 用 DISTINCT 消去重复的记录 ................................................................................................ 4 用 WHERE 子句说明选择记录的条件 ..................................................................................... 4 选择条件 ................................................................................................................................... 4 连接条件 ................................................................................................................................... 4 SQL 和宏 ......................................................................................................................................... 4 SQL 和字母大小写 .......................................................................................................................... 5 SQL 和索引 ..............................................................................