Nner Join joins two tables, three tables, five tables of SQL statements2013-04-14 15:13: 11来 Source: West e-Net SQL INNER join keyword indicates that the INNER join keyword returns a row when there is at least one match in the table. The SQL INNER Join keyword indicates that the INNER join keyword returns a row when there is at least one match in the table. 1, connecting two data Tables usage: from Member INNER JOIN membersort on Member.membersort=membersort.membersort Syntax format can be summarized as follows: From table 1 INNER JOIN table 2 on table 1. Field number=table 2. Field Numbers2, connecting three data Tables usage: from (Member INNER JOIN membersort on Member.membersort=membersort.membersort) INNER JOIN memberlevel on member.memberlevel=the Memberlevel.memberlevel syntax format can be summarized as: from (table 1 INNER JOIN table 2 on table 1. Field number= table 2. Field number) INNER JOIN table 3 on table 1. Field number =table 3. Field Numbers3, connection Four data Tables usage: from ((Member INNER JOIN membersort on Member.membersort=membersort.membersort) INNER join Memberlevel on Member.memberlevel=memberlevel.memberlevel) INNER join Memberidentity on member.memberidentity=the memberidentity.memberidentity syntax format can be summarized as: from (table 1 INNER JOIN table 2 on table 1. Field number= table 2. Field number) INNER join table 3 on table 1. Field number = Table 3. Field number INNER join table 4 on Member. Field number =table 4. Field Numbers4, connection Five data Tables usage: from (((Member INNER JOIN membersort on Member.membersort=membersort.membersort) INNER join Memberlevel on Member.memberlevel=memberlevel.memberlevel) INNER join Memberidentity on member.memberidentity=memberidentity.memberidentity) INNER JOIN wedlock on member.wedlock=the Wedlock.wedlock syntax format can be summarized as: from ((Table 1 INNER JOIN table 2 on table 1. Field number= table 2. Field number) INNER join table 3 on table 1. Field number = Table 3. Field number INNER join table 4 on Member. Field number = Table 4. Field number) INNER join table 5 on Member. Field number = Table 5. Field number
Nner join joins two tables, three tables, five tables of SQL statements