2020-02-16 标签:sql,server,交叉,查询,case,代码,如下,所示,结构,appraiser,access,实现,transform,first,valuerid,select,quarterid,landcode

代码如下所示：表landundertake结构如下所示：表appraiser结构如下所示：access代码：实现代码如下： TRANSFORM First(Landundertake.valuerId) AS valuerId之First SELECT Appraiser.quarterId, La