Electric meter ID num
411528101001, 413001452528524558,
411528101002, 413002510002530145,
YongDianHu name code address ID
Zhang wenbo 52526324 garden 1 unit 411528101001
Li si 52638847 wenbo garden 2 unit 411528101002
Synthesis of new temporary table electric meter information
ID num name code address
411528101001 413001452528524558 52526324 zhang wenbo garden unit 1
Unit 52638847, 411528101002, 413002510002530145, dick, and harry wenbo garden 2
Table 1. Use the select field 1, table 1. Field 2, table 2. 1 the from field to table 1 and table 2 where table 1. ID=table 2. ID and new temporary tables can come out but no data, consult everybody how to generate the above for a great god
CodePudding user response:
https://blog.csdn.net/u010498402/article/details/78038553