The create table property registration data sorting as
Select C *, D.D BSJ AS deng pu time from
(select a. SM, A.Y WH, A.Y XTDJLXMC, B.B DCDYH AS real estate unit number, B.B DCQZH AS registration certificate of real estate, A.Q SZT, B.Q wisco AS type, registration rights B.Q LR obligee name, a. d. JLX, a. DCQZH AS real estate property certificate number, a. d. JJG AS real estate registration organ, a. d. JYY AS real estate registration, A.T DSYQR housing land use right, A.Q wisco AS property rights type, B.Z L, a. d. JSJ AS registration time
The from FDCQ A LEFT JOIN DJFZ_CQZS B on a. SM=B.Q LBSM) C LEFT JOIN SH D on mount SM=D.Q LBSM
What this means????????????????

CodePudding user response:

Create table housing registration data sorting, data sources are the following SQL
Select C *, D.D BSJ AS deng pu time from
(select a. SM, A.Y WH, A.Y XTDJLXMC, B.B DCDYH AS real estate unit number, B.B DCQZH AS registration certificate of real estate, A.Q SZT, B.Q wisco AS type, registration rights B.Q LR obligee name, a. d. JLX, a. DCQZH AS real estate property certificate number, a. d. JJG AS real estate registration organ, a. d. JYY AS real estate registration, A.T DSYQR housing land use right, A.Q wisco AS property rights type, B.Z L, a. d. JSJ AS registration time
The from FDCQ A LEFT JOIN DJFZ_CQZS B on a. SM=B.Q LBSM) C LEFT JOIN SH D on mount SM=D.Q LBSM

With the two left outer join,

Incredibly table and field names in Chinese name, is enough

CodePudding user response:

The create table property registration data sorting as select * from a, b where.


This is to create a new table, the new structure and the back of the query result is consistent, and with these data, the new list

CodePudding user response:

Is the create table MM as the select

CodePudding user response:

Select fields from a left link table b (table) left outer join table c, search out things to create a new table, probably so