The select t.z DDM, t.b dcdyh, t.t DZL, t.q LRZJLX, t.q LRMC, t.q LRZJHM, t.q LRTXDZ, t.q LRLX, t.x MMC, t.f JMS, t.d cy, t.d CRQ,
T2. MPH, t2 ZRZH, t2. ZTS, t2. ZCS, t2. SCJZMJ, t2. Ghyt, t2. Bz
The from (select ZDDM, bdcdyh TDZL, QLRZJLX, QLRMC, QLRZJHM, QLRTXDZ, QLRLX, XMMC, FJSM and dcy, DCRQ
The from dc_djdcbxx,
(select FWXZ fwyt1, FWJG cqly, QTGSD, QTGSN, QTGSX, QTGSB, JGSJ
The from dc_h_fwzk) t1,
(select cb from dc_h) t3) t
Left the join
(select MPH, ZRZH ZTS, ZCS, SCJZMJ, ghyt, bz, ZDDM
The from t2 dc_z)
On t.z DDM=t2. ZDDM
Could you tell me why I did not find the t1 table and t3 table data?

CodePudding user response:

T1 and t3's not written in the select, strange strange can be found out

CodePudding user response:

reference 1st floor stelf response:

t1 and t3's not written in the select, can be found to come to the strange strange

I added after the identifier is unusual, how be to return a responsibility excuse me?

CodePudding user response:

You this nested inside layers, from inside to outside to add, had better take the table alias, etc

CodePudding user response:

reference stelf reply: 3/f

you inside this nested several layers, from inside to outside to add, it is better to take the table alias such as

Has been solved, thank you