SELECT * FROM table1 inner join table2 on Table1.id=table2.id
In fact INNER JOIN ... The syntax format for on is summarized as follows:
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 X on Member. Field number = table X. Field number
You just have to apply the format.
Connection two data tables usage: From Member INNER join Membersort the on Member.membersort=membersort.membersort syntax format can be summarized as: From table 1 INNER join table 2 On table 1. Field number = Table 2. Field number connection three data tables usage: from (Member INNER join Membersort on Member.membersort=membersort.membersort) INNER join Me Mberlevel on Member.memberlevel=memberlevel.memberlevel syntax 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 connection four data tables usage: from ((Member INNER join Membersort on Member.membersort=membersort.membersort) INNER join Me Mberlevel 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 J OIN table 4 on Member. Field number = Table 4. Field number connection Five data Tables usage: From ((((Member INNER JOIN membersort on Member.membersort=membersort.membersort) I Nner join Memberlevel on Member.memberlevel=memberlevel.memberlevel) INNER join memberidentity on member.memberidentity =memberidentity.memberidentity) INNER JOIN wedlock on Member.wedlock=wedlock.wedlock syntax 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
SQL server--joins multiple tables with join on