access sql语句查询

发布时间:2017-1-18 17:57:05 编辑:www.fx114.net 分享查询网我要评论
本篇文章主要介绍了"access sql语句查询",主要涉及到access sql语句查询方面的内容,对于access sql语句查询感兴趣的同学可以参考一下。

  查询时生成序号SELECT (SELECT Count([xlh].[aa]) AS AutoNum FROM xlh WHERE  (((xlh.aa)<=xlh_Alias.aa));) AS 序号, xlh.aaFROM xlh AS xlh_Alias INNER JOIN xlh ON xlh_Alias.aa=xlh.aaORDER BY xlh.aa; 多表sql查询SELECT test.aa AS 第一个字段, test1.bb AS 第二个字段, test1.ccFROM test, test1WHERE test.aa=test1.aa; 多表sql查询1SELECT a.aa, b.bb, b.cc, b.cc*100 AS 合计FROM test AS a, test1 AS bWHERE a.aa=b.aa; 多表sql查询排序SELECT a.aa, b.bb, b.cc AS 第三个字段FROM test AS a, test1 AS bWHERE a.aa=b.aaORDER BY b.cc; 查询例子SELECT a.dhhmFROM xl11a AS a, xl919 AS bWHERE a.dhhm=b.dhhm and aa<>"1";日期时间分隔符是#而不是引号Select * From Tab1 Where [Date]>#2002-1-1#;  

上一篇:一条永恒的金带--歌德尔定理
下一篇:PB不能更新表中的计算列

相关文章

相关评论