like的使用.sql

初学者

SELECT STU_NAME,PAPER_NAME/* 通过like查询与"信息"有关的论文名"*/
FROM STUDENT INNER JOIN STU_PAPER ON STUDENT.STU_ID=STU_PAPER.STU_ID 
INNER JOIN PAPER ON PAPER.PAPER_ID=STU_PAPER.PAPER_ID
WHERE PAPER_NAME LIKE'%信息%'