文档介绍:like查询用*
SELECT *
FROM flash
WHERE filename like '*http*';
DELETE *
FROM company_guangxi
WHERE 机构名称 not like '*公司*' and 机构名称 not like '*工厂*';
删除查询
DELETE * FROM 订单 WHERE <=#1/1/2002#
更新查询
UPDATE 产品 SET = [建议售价]* WHERE ="MOTOROLA"
access sql语句查询
查询时生成序号
SELECT (SELECT Count([xlh].[aa]) AS AutoNum FROM xlh WHERE ((() <=));) AS 序号,
FROM xlh AS xlh_Alias INNER JOIN xlh ON =
ORDER BY ;
多表sql查询
SELECT AS 第一个字段, AS 第二个字段,
FROM test, test1
WHERE =;
多表sql查询1
SELECT , , , *100 AS 合计
FROM test AS a, test1 AS b
WHERE =;
多表sql查询排序
SELECT , , AS 第三个字段
FROM test AS a, test1 AS b
WHERE =
ORDER BY ;
查询例子
SELECT
FROM xl11a AS a, xl919 AS b
WHERE = and aa <>"1";
日期时间分隔符是#而不是引号
Select * From Tab1 Where [Date]>#2002-1-1#;
函数及计算
合计的群组,运算式及条件
SELECT , Sum() AS 含税价之总计, Last() AS 订单日期之最后一笔, Date()-[订单日期之最后一笔] AS 距今天数 FROM 订单 WHERE (>=#12/1/2006#) GROUP BY
11-2 查询指令
群组
条件
多个计算栏位
多资料表查询指令
INNER JOIN-最基本的JOIN方式
SELECT , , FROM 客户 INNER JOIN 订单 ON =
11-2 查询指令
多资料表查询指令
LEFT及RIGHT JOIN
SELECT , , FROM 客户 LEFT