Querying data using SQL statements in Excel (iv)

Today's shared SQL statement connects two tables with a primary key and a where statement.

Let's first look at the data sources for the two graphs.

650) this.width=650; "style=" Float:none; "title=" 1.JPG "src=" http://s3.51cto.com/wyfs02/M01/6D/3C/ Wkiol1ve9jnqktosaak9wdxtwlk691.jpg "alt=" Wkiol1ve9jnqktosaak9wdxtwlk691.jpg "/>

650) this.width=650; "style=" Float:none; "title=" 2.JPG "src=" http://s3.51cto.com/wyfs02/M01/6D/41/ Wkiom1ve9lpceiafaad3keqg3u4148.jpg "alt=" Wkiom1ve9lpceiafaad3keqg3u4148.jpg "/>

Below we create a data connection via OLE BD and then enter the statement, please refer to the previous blog post.

For example, the No column in Sheet1 is used as the primary key.

650) this.width=650; "title=" 4.JPG "src=" Http://s3.51cto.com/wyfs02/M02/6D/41/wKiom1Ve9YKhVmKwAAHZmf1D65M638.jpg " alt= "Wkiom1ve9ykhvmkwaahzmf1d65m638.jpg"/>

The result of the operation is as follows, of course, the function here with VLOOKUP can also be achieved, but we slowly from the base statement, then there will be unexpected features.

650) this.width=650; "style=" Float:none; "title=" 3.JPG "src=" http://s3.51cto.com/wyfs02/M00/6D/3C/ Wkiol1ve9kkqfhrqaalpl8a3plg462.jpg "alt=" Wkiol1ve9kkqfhrqaalpl8a3plg462.jpg "/>

This article is from the "Guo Yong Technology blog" blog, make sure to keep this source http://guoyong.blog.51cto.com/408495/1653966

Querying data using SQL statements in Excel (iv)