INNER JOIN 联接多个表（国外英文资料）.doc

INNER JOIN 联接多个表（国外英文资料） The INNER JOIN joins multiple tables There are two tables, the article Id column of the TypeId field records in the table, the column in the table field is the item Id and the item name, to achieve the effect of now is to read the article shows the column name list. The inner join operation was never used before, so there was nothing to do. There are some features that can be implemented just by SQL statements, and the inner join can combine records in two tables, as long as there is a consistent value in the common field. So to display the column name, simply use the following SQL statement: Select [Article]. Id, [Article]. The content, [column table]. [column name] FROM [Article] inner join [column table] on [column table] id = [Article] ArType orDER BY DESC [ArId] -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Accompanying article: Multi-table join to establish record set is very useful, because in some cases, we need to display digital data type for the corresponding text name, its met multi-table join the establishment of a recordset. As a member registration system, for example, there are five tables, membership information data table member, member status table MemberIdentity, permissions table MemberLevel, member category table MemberSort and marital status table Wedlock. If you want to display all the member registration information, certainly will these four tables together, otherwise we see some members of the information may be only data number. For membership category table in the data table, 1 on behalf of the members, 2 on behalf of the senior members, three representative life member, when in the show, if not associated member category table with detailed data sheets, so if we see now is a ordinary member registration information, we can onl