create table 房产登记数据整理 as
select C.*,D.DBSJ AS 登溥时间 from
(select A.BSM,A.YWH,A.YXTDJLXMC,B.BDCDYH AS 不动产单元号,B.BDCQZH AS 登记不动产证书号,A.QSZT,B.QLLX as 登记权利类型,B.QLR 登记权利人名称,A.DJLX,A.BDCQZH AS 房产不动产证书号,A.DJJG AS 房产登记机构,A.DJYY AS 房产登记原因,A.TDSYQR 房产土地使用权人,A.QLLX as 房产权利类型,B.ZL,A.DJSJ AS 登记时间
from FDCQ A LEFT JOIN DJFZ_CQZS B on A.BSM=B.QLBSM) C LEFT JOIN SH D on C.BSM=D.QLBSM
这个什么意思啊????????????
select C.*,D.DBSJ AS 登溥时间 from
(select A.BSM,A.YWH,A.YXTDJLXMC,B.BDCDYH AS 不动产单元号,B.BDCQZH AS 登记不动产证书号,A.QSZT,B.QLLX as 登记权利类型,B.QLR 登记权利人名称,A.DJLX,A.BDCQZH AS 房产不动产证书号,A.DJJG AS 房产登记机构,A.DJYY AS 房产登记原因,A.TDSYQR 房产土地使用权人,A.QLLX as 房产权利类型,B.ZL,A.DJSJ AS 登记时间
from FDCQ A LEFT JOIN DJFZ_CQZS B on A.BSM=B.QLBSM) C LEFT JOIN SH D on C.BSM=D.QLBSM
这个什么意思啊????????????
select C.*,D.DBSJ AS 登溥时间 from
(select A.BSM,A.YWH,A.YXTDJLXMC,B.BDCDYH AS 不动产单元号,B.BDCQZH AS 登记不动产证书号,A.QSZT,B.QLLX as 登记权利类型,B.QLR 登记权利人名称,A.DJLX,A.BDCQZH AS 房产不动产证书号,A.DJJG AS 房产登记机构,A.DJYY AS 房产登记原因,A.TDSYQR 房产土地使用权人,A.QLLX as 房产权利类型,B.ZL,A.DJSJ AS 登记时间
from FDCQ A LEFT JOIN DJFZ_CQZS B on A.BSM=B.QLBSM) C LEFT JOIN SH D on C.BSM=D.QLBSM用了两个左外连接。居然表名和字段名都用中文名称,够奇葩
这个是建立一个新表,新的结构和后面的查询结果一致,并且新表中有这些数据。
select 字段 from (表a 左外链接 表b ) 左外连接表c ,搜索出来的东西新建一个表,大概如此