代码如下所示:
表landundertake结构如下:
表鉴定人的结构如下:
访问代码:
复制代码代码如下所示:
第一次转变(landundertake。valuerid)作为valuerid第一
选择appraiser.quarterid,Landundertake.landCode
从landundertake内加入鉴定人(landundertake.valuerid =鉴定。valuerid)和(landundertake.quarterid = =)
集团通过appraiser.quarterid,Landundertake.LandCode
枢landundertake.valuergrade;
sql
服务器代码:
复制代码代码如下所示:
选择dbo.appraiser.quarterid,dbo.landundertake.landcode案例,dbo.landundertake.appraisergrade when'appraiserid1'then dbo.landundertake.appraiserid别的空结束appraiserid,案例dbo.landundertake.appraisergrade when'appraiserid2然后dbo.landundertake.appraiserid别的空结束appraiserid1
从dbo.landundertake内部联接
Dbo。评估师对dbo。landundertake。quarterid = dbo.appraiser.quarterid和dbo。landundertake appraiserid = dbo.appraiser.appraiserid。
通过dbo.appraiser.quarterid,dbo.landundertake.landcode,dbo.landundertake.appraisergrade组,dbo.landundertake.appraiserid
跨表
查询结果如下: