å
¶å®å¤è¡¨æ¥è¯¢ï¼ç¨å°çå
³é®åï¼å°±æ¯åinner join,left join,right join ä¹ç±»çï¼æ ¹æ®å
·æ¬æ
åµï¼éæ©èªå·²éåçè¿æ¥è¯å¥ã
举个ä¾åå§
select a.studnt_sno,b.sno,c.grade from studnt as a inner join depart as b on a.sno=b.sno left join sc as c on b.cno=c.no
温馨提示:答案为网友推荐,仅供参考