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 · 158 阅读 · 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 · 1294 阅读 · 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 · 1794 阅读 · 0 评论