like的使用.sql

来自「初学者」· SQL 代码 · 共 4 行

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'%信息%'