For beginners, don't throw bricks
Writing SQL statements has always been a bit confusing. When writing SQL statements, there is no good error checking mechanism, and errors can only be found at runtime, especially when there are more than one associated table, my thoughts may be confused and I don't know where I am lost. Recently, it was accidentally discovered that M $ did not provide a good silly interface for our lazy students to use, but we turned a blind eye to ourselves, that is, the view Manager in SQL Server, it not only makes it easy for us to query multiple tables without ignoring the relationship between them (of course, there must be a necessary relationship between multiple tables ), you can also use it to set aliases, sorting, conditions, and so on, and then automatically generate good-style SQL SELECT statements, and test the running results. Let's talk about this nonsense. Let's take a look at the image below and try it on our own :-)
(