mysql - SQL语句跨关系访问数据

Question

我的 SQL 数据库中有以下表:

authors:
    name varchar
    id int Primary Key
publications:
    id int Primary Key
    title mediumtext
    year int 
authorsJoinTable: 
    authorId -> Foreign Key to the authors table
    publicationID -> Foreign Key to the publications Table
    sequenceId int

我想知道是否可以从 authorsJoinTable 获取所有 publicationIds按年份降序排列？
提前致谢，
院长

Answer 1

SELECT publicationID
FROM authorsJoinTable a JOIN publications p
     ON (p.Id = a.publicationId)
ORDER BY p.Year DESC