SQL Statement to access data across relationships

Question

Hi, I have the following tables in my SQL Database:

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

I am wondering if it is possible to get all the publicationIds from the authorsJoinTable ordered by year descending?
Thanks in Advance,
Dean

Answer 1

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

Answer 2

 SELECT publicationID FROM authorsJoinTable JOIN publications AS P ON P.id = publicationID ORDER BY P.year DESC