![](https://img-blog.csdnimg.cn/20201014180756923.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Access
花舞月咏潭
小大不同,日新月异,
展开
-
Access从2张表里面查土地证号挂接
SELECT ZD_DJDCB.TDQSLYZMCL from ZD_DJDCB;SELECT ZD_DJDCB.TDQSLYZMCL,ZD_DJDCB.DJH from ZD_DJDCB;SELECT ZD_DJDCB.TDQSLYZMCL,ZD_DJDCB.DJH from ZD_DJDCB INNER JOIN Sheet1 ON ZD_DJDCB.DJH=Sheet1.宗地代码 ;原创 2020-12-29 13:04:07 · 157 阅读 · 0 评论 -
Access在表中查询字段方法-1
1 SELECT TextString from Town_name ; //从Town_name表中查询TextString.2 SELECT SUM(TextString ) from Town_name ;//对字段求和原创 2019-10-02 19:16:49 · 1280 阅读 · 1 评论 -
Access在表中查询字段方法-2
1SELECT Speed,meters,Name from Road where Speed=30; //查询速度为30的道路2SELECT Speed,meters,NAME from Road where name like "???";//查询三个字的道路名称原创 2019-10-09 07:13:42 · 1783 阅读 · 0 评论