3. sql写法 内连接inner join: SELECT msp.name,party.name FROM msp JOIN party ON party=code 或 SELECT msp.name,party.name FROM msp inner JOIN party ONparty=code 左连接left join : SELECT msp.name,party.name FROM msp LEFT JOIN party ON party=code 右连接right join : SELECT msp.name,party.name FROM msp RIGHT JOIN party ONmsp.party=party.code
全连接(full join): SELECT msp.name, party.name FROM msp FULL JOIN party ONmsp.party=party.code