For beginners, the veteran don't throw bricks
Writing SQL statements has always been a relatively curious thing, written without a good error-checking mechanism, can only be run to find errors, especially the associated table more up, thoughts will inevitably be confused at last I do not know where to lose. The recent accidental discovery is not m$ did not provide a good fool interface to our lazy brother Lazy brothers use, but we ourselves ignore, that is, SQL Server view Manager, Not only does it allow us to easily query across multiple tables without having to ignore their relationship (of course, there must be a necessary relationship between multiple tables), you can also use it to set up aliases, sorting, conditions, and so on, and then automatically generate a good-style SQL SELECT statement, and you can test the results of the run. That's the point, look at the picture below and try it yourself.:-)
(
http://www.bkjia.com/PHPjc/631008.html www.bkjia.com true http://www.bkjia.com/PHPjc/631008.html techarticle dedicated to beginners, the birds don't throw bricks. Writing SQL statements has always been a matter of wonder, writing without a good error-checking mechanism, can only run to find errors, especially the association ...